topic Re: Synthetic Keys and Column as rows in QlikView

Synthetic Keys and Column as rows

Wed, 01 Jul 2015 10:11:29 GMT

Hi All

I have three basic questions:

If i have multiple synthetic tables created , will it affect the performance of the dashboard??
If i am getting the data in rowwise manner instead of columns, ie instead having ITEM , ITEM CATEGORY and ITEM VALUE as two seperate columns, i have them as rows.(ITEM1 then next row is ITEM CATEGORY and have corresponding values in ITEM valueas column). Can i use Set expression to handle this? will use of multiple SEt affect the performance.
Can i use Set expression when using a calculated dimension??

Thanks in advance!!!!

Regards

Ganesh

Gysbert_Wassenaar — Wed, 01 Jul 2015 11:33:03 GMT

1. Very likely

2. Maybe you can use set analysis. But unless you explain what exactly you wish to 'handle' there's no telling. Every expression affects performance.

3. Yes.

avinashelite — Wed, 01 Jul 2015 11:37:12 GMT

1.synthetic keys will surely affect the performance and even in the calculation .

2. It completely depends on the requirement , in few cases the columns representation works fine and in few the row wise works good .

3.if you talking about set analysis in the calculated dimension, then we cannot do but we can achieve it using conditional and aggr functions