Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

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

GetSelectedCount(UserID) = 0

GetPossibleCount(UserID) = 25

count(UserID)=25

View solution in original post

7 Replies
mambi
Creator III
Creator III

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

Not applicable
Author

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
MVP
MVP

in a chart you can use

- calculation condition in general tab

- show conditional in layout tab

with getselectedcount, getpossiblecount, count(somefield)

Not applicable
Author

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
Author

Hi,

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

Matt

mambi
Creator III
Creator III

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
MVP
MVP

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

GetSelectedCount(UserID) = 0

GetPossibleCount(UserID) = 25

count(UserID)=25