topic Re: Conditional Show on a Count of People in QlikView

Conditional Show on a Count of People

michaelneck — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm looking for a way to limit down my application so that if the selected drilldown filter results in less than 5 people being selected the the object will go blank, I have tried creating a variable to only get where there is more than 5 people and using it with conditional show withing the object but does not seem to be functioning correctly:

=GetPossibleCount(PERSONNEL_NUMBER)>5

=GetSelectedCount(PERSONNEL_NUMBER)>5

Does anyone know of a way to do this?

Any help would be greatly appreciated.

Thanks,

Michael

Re: Conditional Show on a Count of People

shiveshsingh — Mon, 16 Apr 2018 13:18:28 GMT

Can you share the app? and highlight the requirement

Re: Conditional Show on a Count of People

michaelneck — Mon, 16 Apr 2018 13:26:02 GMT

Sorry, I cannot share the app due to the sensitivity of the information, its essentiallyy a count of staff members only I would like when lets say someone filters down by area and that results in the count of staff members being less than 5 I would like the object to be hidden. The issue is that the

=GetPossibleCount(PERSONNEL_NUMBER)>5

seems to always show that data no matter what the number filters down to and the

=GetSelectedCount(PERSONNEL_NUMBER)>5

seems to always hide the information no matter what number it filters down to..

Re: Conditional Show on a Count of People

vishsaggi — Mon, 16 Apr 2018 14:03:48 GMT

Your get selected count should work. Can you tell us what is the object you are using like Straight table or Pivot table or a chart? Usually for a Straight table I would do below

you can give the below expr and when Personnel_Number is > 5 then it will show the data else no data will be displayed.

If you want to show hide then use in layout tab - conditional check

Re: Conditional Show on a Count of People

MarcoWedel — Mon, 16 Apr 2018 21:18:29 GMT

maybe something like

=Count(Distinct PERSONNEL_NUMBER)>5

regards

Marco