topic Re: Show blank chart until selections are made in QlikView

Show blank chart until selections are made

Tue, 25 Nov 2014 16:42:16 GMT

Is this possible? This chart isn't meant to be looked at with all selections:

I want it to be blank and then when a selection is made:

Thanks!

Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:44:34 GMT

on the expressions tab you can make the expression calculation conditional e.g count(My_Field) < 10

Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:45:08 GMT

Hi Joe,

you can add a calculation condition to the chart, using something like getpossiblecount() of the field you are displaying

Hope that helps

Joe

Re: Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:47:42 GMT

Here is an example where I don't want the chart to draw unless they selections are made on the Programme field:

Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:50:31 GMT

Please see attached, you can then put in a custom message for the calculation condition to make the user aware of the condition

Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:50:35 GMT

I've never heard of getpossiblecount before. Much appreciated!

Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:52:54 GMT

By the way, what was the sum of all the studly cats?

Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:55:22 GMT

it is useful when you are filtering down using other dimensions but only want to show once you limit down enough.

Eg you might make a selection on a product group or product type but not the project ID itself but only want to display ID's once you limit down to 10

Re: Show blank chart until selections are made

Tue, 25 Nov 2014 16:55:28 GMT

Thats between me and the cats