topic Re. :Hide expressions if no values in QlikView

Hide expressions if no values

matzas — Mon, 07 Jun 2010 15:35:39 GMT

Is it possible to hide expressions when there is no values?

Fex: I want to hide "Female"

	Female	Male
xxxx	0	43
xxxx	0	41

Best regards

Re. :Hide expressions if no values

martin59 — Mon, 07 Jun 2010 15:57:42 GMT

Hi,

You have the 'suppress when value is null' option in the dimension tab of the chart's properties

Re. :Hide expressions if no values

matzas — Mon, 07 Jun 2010 16:24:52 GMT

Thanks.

I would use that if a "Dimension" has value null, but I want to do the same thing when an "Expression" have value null.

Best regards

Re. :Hide expressions if no values

Mon, 07 Jun 2010 17:36:03 GMT

I don't think it is possible, so I'm going to make a bad suggestion that would work on your example, but would be harder with a more complicated example. Make multiple charts. Have on that just shows Male, one that just shows Female and one with both. Then using the Conditional Show (Sum{<Gender={"Female"}> Value)>0) to show the one you want to see.

You could probably even come up with a complicated way to only need as many charts as you have expressions. One for one expression, one for two expressions, etc. And then just make the expressions dynamic based on what you want to show.

Like I said, not a very good suggestion.

Re. :Hide expressions if no values

johnw — Mon, 07 Jun 2010 20:05:13 GMT

Attached are a couple of approaches using this data table:

LOAD * INLINE [
Type, Sex, Value
AAAA, Male, 43
BBBB, Male, 41
CCCC, Female, 52
];

Select types AAAA and BBBB to see the Female columns disappear.

The first chart is a pivot table. If there is no data for the column, it will naturally be removed in a pivot table, no special effort on your part.

The second chart is a straight table with separate expressions for Female and Male. It then uses a conditional show on the presentation tab, where the condition IS the expression. Therefore, if the expression evaluates to 0 or null, it won't display the column. This might not be EXACTLY what you want if there are negatives, since if the positives and negatives add to 0, it would also exclude the column. That can be fixed as well, but wouldn't be worth the extra trouble if you don't have negative values.

Re. :Hide expressions if no values

Tue, 26 Apr 2011 19:32:04 GMT

Is there any way to get this solution to work with a bar chart?

Re. :Hide expressions if no values

johnw — Wed, 27 Apr 2011 01:56:24 GMT

Well, in the example, the trivial way is to just make Sex a second dimension instead of using two expressions. We'll assume your real case isn't that simple.

One way I'm thinking to do it is make three charts (for the example). One with just female, one with just male, and one with both. Then only display the appropriate chart. That would get pretty ridiculous for anything more than a couple expressions, though, since you'd have to have a chart for every combination of expressions.

Ah, probably a better way to do it is with a valuelist. Make a value for each of your expressions. Then combine all your expressions into one with a pick(match()) to get the right expression.

See attached for all three solutions.

Re: Re. :Hide expressions if no values

sandy2671 — Fri, 14 Sep 2012 13:19:54 GMT

Thanks a Ton John,

This resolved my issue as well !!!

Re: Hide expressions if no values

whiteline — Fri, 14 Sep 2012 14:57:41 GMT

The answer depends on what version of QV you use.