pivot table/tab selections

yelin_nyu — Wed, 10 Jul 2013 18:03:31 GMT

which method would require most calculation time?

I have mutiple tabs in a qvw, and each tab has a number of calculations, objects. say I want 2 of those tabs to bear certail criteria for all of the objects within the tab. (let's say one table is to look at young female population and another tab is to look at all population)

There are couple of ways i could do this: (in a pivot table)

1.set analysis in every expression, every objects

2.use dimension flag to filter out nulls, say if(gender='f' and age='<25', Review_Date)

3.use tab trigger, selection automatically applied upon entering the tab, and clearing when leaving the tab.

1 is so cumbersome and makes the expression really long

2 seems to render too much, maybe it's all in my head

3 i like a lot, but i don't know if it would slow down the performance. and also users could accidentally clear the selections.

Please advise

Thanks

Re: pivot table/tab selections

Gysbert_Wassenaar — Thu, 11 Jul 2013 11:08:32 GMT

Option 3 will likely perform best. You could also use bookmarks. By activating a bookmark with the OnActivate sheet trigger you don't have a problem if users clear selections.

If you're using QV11 you can also try using alternate states. You can create alternate states on the General tab of the document properties window. After creating alternate states (1 for each tab) assign them to the sheets on the General tab of the sheet properties window. The objects on the sheet will inherit the alternate state assigned to the sheet. Selections on one sheet will now only affect the objects on the same sheet.

topic pivot table/tab selections in QlikView

pivot table/tab selections

Re: pivot table/tab selections