topic Re: nested if() value in QlikView

nested if() value

Tue, 15 Oct 2013 09:11:23 GMT

Hey guys,

I'm struggling with an easy problem (I think it's easy anyway).

I've got a dimension called "group" with values "set1", "set2", "set3", ....

Each value has got it's own target (sales):

set1 = 10.000 euro

set2 = 20.000 euro

set3 = 30.000 euro

I've got a chart (table) that shows the current sales for each set. In the second column (second expression), it should show me the target for each set.

(I know I can add a new field, but I do not want to touch the codes).

So I was thinking something like:

=if (group = {'set1'}, 10000, if (group = {'set2'}, 20000, .... })

See where I am going? Like a nested if-function in Excel..

Does anyone know how to enter the expression?

Thanks a lot!

Zipke

Re: nested if() value

swuehl — Tue, 15 Oct 2013 09:16:05 GMT

If I understand correctly, your idea should work:

=if (group = 'set1', 10000, if (group = 'set2', 20000, .... ))

or maybe like

=pick(match(group,'set1','set2'),

10000,

20000

)

edit:

Or just create a INLINE table in your script and use the associative logic:

LOAD * INLINE [

group, target

set1, 10000

set2, 20000

];

Then just use an expression

=only(target)

Re: nested if() value

tresB — Tue, 15 Oct 2013 09:17:49 GMT

Put the expression simply like: = FieldNameWithTargetData

Or, if you want the numeric representation may try: =Num(Subfield(TragetField, '.', 1))*1000

Re: nested if() value

Tue, 15 Oct 2013 09:19:48 GMT

Ha alright, the first part of you reply actually worked. It didn't work when I did it because of the { } I used..

Thanks, I think I've got it already!

Will also try the other options! May be useful at some point in life

Re: nested if() value

Tue, 15 Oct 2013 09:26:08 GMT

Hey tresesco, thank you for your reply.

Can you please explain me the first part of your reply? What does this actually do?

(The second part won't be useful, I just used those number 1> 10000, 2> 20000, ..., to make the communication easier, but they are not the correct numbers. But it would have been a clever solution tough! Thanks! )