topic Re: Dimension not displaying in QlikView

Dimension not displaying

Anonymous — Fri, 29 May 2015 14:21:36 GMT

if(hold_1 = '043' or hold_2 = '043' or hold_3 = '043' or hold_4 = '043' or hold_5 = '043' or other= '043', 'ment', If(cd = 'DD' or cd = 'SV', 'Core', 'Cert'))

If this is the if-statement I am using, how do I get the dimension 'ment' to appear even when it doesn't satisfy the if-statement... I would like 'ment' to be displayed with all zeroes if it does not satisfy the if-statement

Is there any way this is possible?

Re: Dimension not displaying

alexandros17 — Fri, 29 May 2015 14:25:12 GMT

Use show all values in ìdimension tab but ... have you added an expression in your chart?

Re: Dimension not displaying

awhitfield — Fri, 29 May 2015 14:25:28 GMT

Hi Ashley,

any chance that you could upload your QVW please?

Andy

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 14:27:35 GMT

Yes there are many expressions. And the 'show all values' selection is grayed out for this dimension

Re: Dimension not displaying

Clever_Anjos — Fri, 29 May 2015 14:27:55 GMT

Uncheck "Supress Zero Values" at Presentation tab

Re: Dimension not displaying

alexandros17 — Fri, 29 May 2015 14:28:56 GMT

Then uncheck "suppress zero values" in presentation tab

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 14:29:27 GMT

Unfortunately I have tried this and it does not work

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 14:30:52 GMT

Also, changes nothing in what I am looking for unfortunately.

Re: Dimension not displaying

stigchel — Fri, 29 May 2015 14:33:14 GMT

Although it is usually better to create things like this in the load script (assuming that there is at least 1 record satisfying your if condition for 'ment') You could use a synthetic dimension e.g.

=ValueList('ment','Core','Cert')

You can reference the dimension in your calculating expression by repeating it e.g.

if(ValueList('ment','Core','Cert')='ment', MyCalcForMent, if(......

And in the dimension tab uncheck suppress null and in the presentation tab zero values.

Re: Dimension not displaying

alexandros17 — Fri, 29 May 2015 14:34:48 GMT

Then Try This:

if(hold_1 = '043' or hold_2 = '043' or hold_3 = '043' or hold_4 = '043' or hold_5 = '043' or other= '043', 'ment', If(cd = 'DD' or cd = 'SV', 'Core', 'Cert'),'0000')

let me know

Re: Dimension not displaying

awhitfield — Fri, 29 May 2015 14:39:33 GMT

Doesn't your expression mean

if(hold_1 = '043' or hold_2 = '043' or hold_3 = '043' or hold_4 = '043' or hold_5 = '043' or other= '043', IF TRUE then display 'ment',

IF False use If(cd = 'DD' or cd = 'SV', 'Core', 'Cert'))

If you wanted it to display 'ment' or '0000', should it not be something like

if(hold_1 = '043' or hold_2 = '043' or hold_3 = '043' or hold_4 = '043' or hold_5 = '043' or other= '043', 'ment', '0000')

Also if ment is a dimension there should NOT be single quotes around it

Andy

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 14:40:11 GMT

Creating the dimension worked to have all the titles displayed. Now do I create a new expression with that reference to the dimension in it?

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 14:42:12 GMT

the if statement I sent is a dimension, not expression. And no it does not mean that because I want all three displayed... 'Ment' Cert and 'Core'

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 14:44:59 GMT

I think this could also be on the right track but the comma before '0000' is an error in the expreession

Re: Dimension not displaying

alexandros17 — Fri, 29 May 2015 14:53:26 GMT

You're right I hadn't seen the else condition in the second if, the problem is: when the if condition is not satisfied?

You have ment, core or cert as result, which condition should return 0 ?

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 14:58:53 GMT

The problem is in the first if-statement. If the hold or other variable are not met, 'ment' does not display in the dimension at all. I would like it to display no matter what even if the fields are all filled with 0's.

eg.

Cert 786 126

Core 200 45

ment 0 0

where as currently it does not have 'ment' as a row at all

Re: Dimension not displaying

stigchel — Fri, 29 May 2015 14:58:59 GMT

A new expression or adjusting your existing to do the correct calculation for each of the values in the valuelist like mentioned in my post

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 15:06:57 GMT

So I have 9 expressions..... what do I do to them to make it work for the synthetic dimension?

Re: Dimension not displaying

Anonymous — Fri, 29 May 2015 15:40:40 GMT

I realized I do not have the one record meeting the condition for 'ment'.... which is why I need a synthetic row for those who do not meet the condition.