topic Re: how to list all if()s in one columm in QlikView

how to list all if()s in one columm

Wed, 02 Jul 2014 09:35:51 GMT

Hi, I just get AmountALL, and the other wont show up,

if I delete AmountALL, the other shows up...

Are there rules of ordering this Ifs ?

My intention is to have a LIST with all of that IF()s as ZGr..

Whats wrong?

Here my script..

Load

If( ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400','T83500'),'AmountALL',

If( ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83500'), 'Direct',

If( ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400'), 'Other',

If( ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400','T83500') and Match("Global Dimension 2 Code",'DE702100024','DE702100025','DE702100026'),'Service' ,

If( ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400','T83500') and WildMatch("Global Dimension 2 Code",'DE7011*'),'Project'

))))) as ZGr

;

Re: how to list all if()s in one columm

Wed, 02 Jul 2014 09:45:15 GMT

Maybe you could provide a sample file? Maybe your missing something at the end.

Re: how to list all if()s in one columm

Wed, 02 Jul 2014 09:49:00 GMT

its the copy of the script,

im working with sql base in my network..

Re: how to list all if()s in one columm

Wed, 02 Jul 2014 10:52:54 GMT

I am aware of that - but sometimes its easier with a sample to try to see whats wrong. If you says it works without the first if, then try to debug why it doesnt work.

Re: how to list all if()s in one columm

marcus_sommer — Wed, 02 Jul 2014 11:33:14 GMT

Your first condition matched all possibilities therefor all further conditions couldn't be true. For this you must put your most complex condition at the first if-loop.

Further it seems that you need more then one field to categorize your data - the first three conditions are the same ...

- Marcus

Re: how to list all if()s in one columm

stigchel — Wed, 02 Jul 2014 12:02:34 GMT

You can use a crosstable load to multiple tag your values, seperate the ifs (an closed if for each value)

Crosstable(MultiFields, Zgr,1)

Load

ID,

...