topic Create a chart that display when a specific date is entered in QlikView

Create a chart that display when a specific date is entered

Wed, 08 Jul 2009 03:31:24 GMT

Hello,

I have created a chart that will display the total count of different products in for this year. The question that I have how can I create a chart that will only display the total amount of products when the month and year is selected. If the month or year isn't selected, I don't want the charat to show anything.

Thank you in advance!

Create a chart that display when a specific date is entered

Wed, 08 Jul 2009 04:18:07 GMT

You can use GetSelectedCount(FieldName) to tell you how many items are selected in a particular field. Then on your chart, set the Conditional Show to require that this value is greater than zero for each field you want to use. Something like:

(GetSelectedCount(Month) > 0 And GetSelectedCount(Year) > 0)

If you still want to show the chart, but have it be empty, then you can use something like the code above on all your expressions.

If(GetSelectedCount(Month) > 0 And GetSelectedCount(Year) > 0, Expression, Null)

Then if you have Suppress Missing checked, you'll only see data if something is selected for Month and Year.

Create a chart that display when a specific date is entered

Anonymous — Wed, 08 Jul 2009 07:12:46 GMT

And to add one more to NMiller's suggestion, if I may...
To keep the chart as placeholder, not hiding it completely, you can use the same condition in Calculating Condition instead of Show Condition. If it is not met, there will be the blank chart placeholder with the default message "Calculated condition unfulfilled". But you can customize it as well, to something like "Please select year and month"

Re: Create a chart that display when a specific date is entered

harishicon — Fri, 08 Jul 2016 16:08:15 GMT

can u tell me how to do the same in the qliksense?