topic View Based on Selection in QlikView

View Based on Selection

Anonymous — Mon, 25 Jul 2016 15:20:34 GMT

Hi all,

I have a problem in the front end of the application where I have 5 views, in which first and second views (Sheet 1 and sheet 2)shows the same data, third and fourth View(Sheet 3 and sheet 4) show the same data and View five (Sheet 5 ) is independent.

Please help me to show the following results

If any selection is made in View1 which is mainly graphs (Sheet 1) then the selection should also reflect in view 2(Sheet 2) which is mainly data in pivot table, but the selection should not be reflected in any other views( View 3 ,4 and 5 or sheet 3,4 and 5).

Similarly, If any selection is made in View3 which is mainly graphs (Sheet 3) then the selection should also reflect in view 4(Sheet 4) which is mainly data in pivot table, but the selection should not be reflected in any other views( View 1 ,2 and 5 or sheet 1,2 and 5).

View 5 or sheet 5 data is independent.

Thanks in advance.

Pavan

Re: View Based on Selection

Gysbert_Wassenaar — Mon, 25 Jul 2016 16:31:34 GMT

You can use alternate states. A selection in one alternate state affects only objects using the same alternate state. Create three alternate states on the General tab of the Document Properties window. Then assign the alternate states you created to the sheets on the General tab of the properties window of the sheets.

Re: View Based on Selection

Anonymous — Mon, 25 Jul 2016 18:12:07 GMT

Thanks Gysbert, it works perfect