Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Hiding a chart based on a condition

Hi,

Chart needs to be hided when there is no data to display.

Chart contains Year and Product as a dimension and count(distinct Order_No) as a expression.

This chart should be displayed when count(distinct Order_No)>3...

I have attached the sample file...

1 Solution

Accepted Solutions
MVP
MVP

Hiding a chart based on a condition

Hi

Something like this perhaps?

Max(aggr(count distinct Order_No, Year, Product)) > 3

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies
markmccoid
Contributor II

Hiding a chart based on a condition

Just go to the charts Properties, then to the Layout tab.

On the Layout tab you will find "Show" section that let's you enter a conditional statement to determine whether or not to show the chart.

Just put your statement  "count(distinct Order_No)>3" and that will do it.

Not applicable

Re: Hiding a chart based on a condition

Hi,

If we give  'count(distinct Order_No)>3' it wont consider the dimensions...it will check this condition globally...

If none of the Year&Prod_Id has count(distinct Order_No)>3 then only we need to hide the sheet.

Please see the attachment...

MVP
MVP

Hiding a chart based on a condition

Hi

Something like this perhaps?

Max(aggr(count distinct Order_No, Year, Product)) > 3

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Hiding a chart based on a condition

Or probably Min....

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser