Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to disable chart when number of records are less than a given number?

Hi,

      In order to keep anonymity of the data, I was asked to stop showing data when number of selected records is less than 5. Is this possible? and how?

Thanks

Longmatch

1 Solution

Accepted Solutions
maxgro
Not applicable

Re: How to disable chart when number of records are less than a given number?

when  there isn't UserID selected (ie after Clear)

GetSelectedCount(UserID) = 0

GetPossibleCount(UserID) = 25

count(UserID)=25

7 Replies
mambi
Not applicable

Re: How to disable chart when number of records are less than a given number?

you can try this as condition : GetSelectedCount(YourField)>5

Not applicable

Re: Re: How to disable chart when number of records are less than a given number?

I think Mambi's method will work. You could add this as a calculation condition here:

Screen Shot 2014-07-11 at 13.08.02.png

You can then add a message so users understand why the chart's empty:

Screen Shot 2014-07-11 at 13.08.49.png

maxgro
Not applicable

Re: How to disable chart when number of records are less than a given number?

in a chart you can use

- calculation condition in general tab

- show conditional in layout tab

with getselectedcount, getpossiblecount, count(somefield)

Not applicable

Re: Re: How to disable chart when number of records are less than a given number?

Hi all,

       Thank you for your quick response. I tried your idea but it just did not work. Please refer to the file in the attachment. I think I must have missed something.

Longmatch

Not applicable

Re: Re: Re: How to disable chart when number of records are less than a given number?

Hi,

It does work but your selected user count needs to be greater than 4 for it to populate. See attached.

Matt

mambi
Not applicable

Re: How to disable chart when number of records are less than a given number?

to get your chart working : you should have a listbox of userid then you must select more than 4 userid to get data displayed

maxgro
Not applicable

Re: How to disable chart when number of records are less than a given number?

when  there isn't UserID selected (ie after Clear)

GetSelectedCount(UserID) = 0

GetPossibleCount(UserID) = 25

count(UserID)=25