Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

HIde and show

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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Sorry. Expression should be:

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

-Rob

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Creator III
Creator III

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 

Highlighted
MVP & Luminary
MVP & Luminary

Sorry. Expression should be:

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

-Rob

View solution in original post

Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.