Qlikview - How to associate the objects



I am very new to Qlikview. I am executing a SQL Script using Qlikview. Each and every fields that i use in select statement is getting displayed as different objects. Is there something called merging these fields so that i can show some association between the values in different variables. Some thing similar to spread sheet, where all the variables are associated in a sheet.

I am not even sure whether this is possible in Qlikview. Please help.



If I understand your problem correctly, you are actually selecting all the variables after the data loading step. You should just skip that step after the data load happens. QlikView creates Listbox for all the variables by default. You can avoid that by skipping the step after data load.

Once that is done, you can use straight tables and Pivot tables in QlikView to create the tables you need.

Let me know if that doesn’t help.