topic Re: if statement on Dimension in QlikView

if statement on Dimension

n1ef5ng1 — Thu, 18 Apr 2013 03:49:37 GMT

Hi ,

Say if I have a field name call Potato, inside the Potato, the data consist of 1,2,3,4

if i will to put this code on the Dimension

=if(Potato = '1',1','Others')

The output will be 1 and others(consist of 2,3,4)

however my expected output that I want is 1 and other(consist of 1,2,,3,4)

How do i do it

Thanks in advance

Re: if statement on Dimension

sivarajs — Thu, 18 Apr 2013 06:32:15 GMT

What you are trying is correct, its better use this expression in script and later use that field in your chart

Re: if statement on Dimension

jagan — Thu, 18 Apr 2013 07:40:46 GMT

Hi,

Just load a mapping table like this

LOAD *

INLINE [Potato, PotatoTemp

1, 1

2, Others

3, Others

4, Others];

Now use PotatoTemp as dimension, calculated dimension has impact on performance.

Hope this helps you,

Regards,

Jagan.

Re: if statement on Dimension

Thu, 18 Apr 2013 08:46:20 GMT

Hi,

could you please explain a bit more detailed, what you are trying to achieve?

I'm not clear which outpout for "other" you expect? In your post it seems to me that you want the whole range of "Potato" being displayed in "other" ???

Greetings

Wiley_E

Re: if statement on Dimension

sushil353 — Thu, 18 Apr 2013 10:12:21 GMT

your requirement is not clear,,

Please post some data and explain your issue with example.

HTH

Sushil

Re: if statement on Dimension

stabben23 — Thu, 18 Apr 2013 11:04:37 GMT

Hi,

you should do this in script,

if(Potato=,1,'1', 'Other') as NewPotatoDimension

then use NewPotatoDimension as your dimensionfield.

Re: if statement on Dimension

jvitantonio — Thu, 18 Apr 2013 11:49:38 GMT

=IF(Potato='1', '1', IF(match(Potato, '1','2','3','4')>0, 'Others'))

Re: if statement on Dimension

n1ef5ng1 — Thu, 18 Apr 2013 12:54:52 GMT

Yes you are right, I want the 'others' to represent all in potato

Sent from my iPhone

Re: if statement on Dimension

n1ef5ng1 — Thu, 18 Apr 2013 13:21:53 GMT

Sorry, bad explanation from my side. The data in potato is non numeric

Sent from my iPhone