HIde and show

[smilingjohn]

Hi All ,
Please find the attachment of the Qlikvie file . My requirement is to hide a chart based on one selection called "Cosmatics" from Dept list box and should keep showing everything as it is for other selections from Dept.

Can you expertise please help me on this .
Thanks in advance

[rwunderlich]

Only the Layout pane for the "Sales by Product" chart, you can select conditional and use a conditional expression like:

GetSelectedCount(Dept) = 0 or count({<Dept={'Cosmatics'}>} DISTINCT Dept) = 0

You also wanted to enlarge the other chart when Sales by product was hidden.  I don't know of any automatic way to do that.  You could duplicate the chart, make the duplicate larger, and then use conditional show to chose which one to show. 

-Rob

[smilingjohn]

Thanks for the reply,

I used your expression in layout condition. When i am selecting "Cosmatics" from Dept list box the sales by Product chart is hiding ,
But when I select other Dept it should show which is not showing .

For other Dept selection it should show the sales by product chart

Thanks 

[rwunderlich · Accepted solution]

Sorry. Expression should be:

GetSelectedCount(Dept) = 0 or Max(Match('Cosmatics', Dept) = 0)

-Rob

[Brett_Bleess]

John, if Rob's posts got you what you needed do not forget to return to the thread and use the Accept as Solution button on the post that worked to give him credit for the assistance and to let the other Members know what worked.  If you still require help, please leave an update, but be sure to do one or the other, leaving a post unmarked is frustrating for those that are helping others out.

Regards,
Brett