topic Re: Calculated dimension if-sentence in QlikView

Calculated dimension if-sentence

Wed, 02 Apr 2014 08:11:45 GMT

Hello,

I have two Groups DBoardL and DboardG that include different fields.

Depending on the value of variable vP1 would I use one of the Groups,

but it doesn´t work. What do I do wrong?

if(vP1='21',DBoardL,DBoardG)

kindly

Håkan

Re: Calculated dimension if-sentence

Wed, 02 Apr 2014 08:27:50 GMT

Hi,

Verify that variable reflecting 21 or not?

Please post sample data or app for the expected solution.

Re: Calculated dimension if-sentence

mangalsk — Wed, 02 Apr 2014 08:34:10 GMT

Hello,

Please send sample qvw

Re: Calculated dimension if-sentence

Wed, 02 Apr 2014 08:41:40 GMT

Hi Håkan

What do you mean by "doesn't work"? Is it always displaying DBoardG group as dimension?

Lukasz

Re: Calculated dimension if-sentence

tresB — Wed, 02 Apr 2014 08:43:29 GMT

It seems that group names can't be used in expression. Somebody correct me if I am wrong.

Update: I was trying with an alternative logic using 'Enable Conditional' taking two groups separately as dimension. Even that is not working.

Re: Calculated dimension if-sentence

its_anandrjs — Wed, 02 Apr 2014 08:53:17 GMT

No script is not correct you have to check the variable with field like check 21 with a field

let vP1 = 21;

if(Yourfield = $(vP1),DBoardL,DBoardG)

Hope this helps

Re: Re: Calculated dimension if-sentence

Wed, 02 Apr 2014 09:01:23 GMT

This was my first thought, but groups seem to 'almost' work in the expression (see attached)

Re: Calculated dimension if-sentence

tresB — Wed, 02 Apr 2014 09:13:36 GMT

If you notice carefully, the condition is not actually working on Groups but on fields.

Re: Calculated dimension if-sentence

Thu, 03 Apr 2014 11:42:41 GMT

Hello,

What i suggest is you pull both the groups into dimension list and you can have the enable condition on both the groups like below.

if(vP1='21',1,0) for first Group and if(vP1<>'21',1,0) for second group.

Hope it helps.

Thanks & Regards,

Venkat T

Re: Calculated dimension if-sentence

Thu, 03 Apr 2014 12:21:36 GMT

Hello again,

the if sentence works, but the Groups are treated as a single Field. Only the first field

is used, no drill down is possible., as a stright table it works. I maybee have to create

two different charts and show them depending on the value of vP1.

Re: Re: Calculated dimension if-sentence

Fri, 04 Apr 2014 04:15:50 GMT

Yes, That's true

You won't get drilldown

Re: Calculated dimension if-sentence

PradeepReddy — Fri, 04 Apr 2014 06:04:44 GMT

We can achieve this by taking the 2 groups as 2 dimensions and applying the conditions to enable them.

1) Group1 dimension

V='1' (In enable condition )

2) Group 2 dimension

V<>'1' (In enable condition )

Note: Don't use the IF condition here.

See the same in the attachment. It is working fine for me.

Thanks

Pradeep