topic Re: Show Chart in condition in QlikView

Show Chart in condition

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

Hi,

I Have a straight table chart in my model that with one dimension is country and the expression is number of people that reg.

also i have a condition that only if there is a more then 5 registration show the row.

Now there are some scenarios that are empty table, I want in this scenario not show the table in the model.

How can I implement this?

Thanks !

Re: Show Chart in condition

Gysbert_Wassenaar — Thu, 11 Aug 2016 08:52:22 GMT

On the Layout tab of the properties window enable the Conditional option and enter an expression that returns true or false. Something like =if(sum(aggr(sum({<country={"=count(registrations)>5"}>}1),country)),1,0). I don't know your exact condition so count(registrations)>5 is just a guess of mine.

Re: Show Chart in condition

Anonymous — Thu, 11 Aug 2016 10:16:57 GMT

Hi,

I tried what you offer but it didn't solve my issue. May there is a function that can count the current number of rows in the table?

so i can put this condition instead?

Re: Show Chart in condition

Gysbert_Wassenaar — Thu, 11 Aug 2016 11:47:17 GMT

What exactly is the condition for showing or hiding the table?

Re: Show Chart in condition

Anonymous — Thu, 11 Aug 2016 11:56:00 GMT

It's the same as you wort only I use a variable

$(vDailyDiffFDPOriginState)>5

Re: Show Chart in condition

Gysbert_Wassenaar — Thu, 11 Aug 2016 14:28:11 GMT

Sorry?

Re: Show Chart in condition

mmonfort — Fri, 12 Aug 2016 00:20:52 GMT

Per Gysbert's response and your requirement it seems like you want to keep the table but just hide rows where countries have LESS THAN 5 registrations?

If you have a single dimension as Country then your expression can be =if(count(DISTINCT ID) > 5, count(DISTINCT ID))

Then also make sure you tick the checkbox "Suppress when value is null" on the Country field in the dimension tab.