Show and HIde Expressions

[#1]

Hi

We are using qlikview 10,

my questions I am trying to show and hide 13 expressions.I have gone through   similar post on this issues.but sound very confusing.

I have created a straight table with two dimensions and 13 measure ,which my required is to enable the user to show and hide some measures  out of the 13

I have done a load in line table called checker  not linked to any tables. Then on my straight table under presentation tab,

for each field I have a condition that says Checker  field from my checker table equals 1  show that field so on 2 , 3  until 13 for each measure

the selection is been done on list box with windows checkboxes.

but if I tick more than one the both of them don't display..

Hi Attached file .

[MK_QSL · Accepted solution]

Use below link which might helpful to you..

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

[alexandros17]

The logic seems correct, can you add your example?

[#4]

hi alessandro

I have attached the example.

thanks

Michael

[alexandros17]

Sorry but I don't see anything

[#6]

hi alessandro

I have also attached the Spreadsheet.

thanks

Michael

[#7]

Change your conditional presentations as below

for Admin

=Index(GetFieldSelections(Checker),'Admin') > 0

for Qty

=Index(GetFieldSelections(Checker),'Qty') > 0

for Gross Sales

=Index(GetFieldSelections(Checker),'GrossSale') > 0

for Total Disc

=Index(GetFieldSelections(Checker),'TotalDisc') > 0

Regards,

Sajeevan