topic Re: How to write expression for following requirement? in QlikView

How to write expression for following requirement?

dolly777 — Tue, 19 Sep 2017 09:09:57 GMT

Hi All,

I have following inline table every value is a dimension in another table?

TableRevenueInline:

Load * inline

[

COL

PAS P1@Net List USD

PAS P1@Net Amount

PAS P1@Net Contra

];

in a pivot table I am using 'COL' as dimension

and in expression I have find out

sum (PAS P1@Net List USD) if value is COL='PAS P1@Net List USD'

sum(PAS P1@Net Amount) if COL= 'PAS P1@Net Amount'

sum(PAS P1@Net Contra) if COL = PAS P1@Net Contra

Please help me to write the expression to get the accurate value

tresB — Tue, 19 Sep 2017 09:23:46 GMT

Basic syntax of IF statement is like :

If ( <condition>, <execute when TRUE>, <execute when FALSE>)

Hence, you may try like:

If( COL='PAS P1@Net List USD', sum (PAS P1@Net List USD) ,

If( COL= 'PAS P1@Net Amount', sum(PAS P1@Net Amount),

If( COL = 'PAS P1@Net Contra', sum(PAS P1@Net Contra) )))

hari8088 — Tue, 19 Sep 2017 09:26:09 GMT

Hi,

As i see if your doing some aggregation function it should be numeric value but as per your requirement it seems your summing strings

elaborate the requirement it means is there any data linked to NEt list usd ,Netamount &Netcontra.

shraddha_g — Tue, 19 Sep 2017 09:26:47 GMT

pick(wildmatch(COL,'PAS P1@Net List USD','PAS P1@Net Amount','PAS P1@Net Contra'),

sum (PAS P1@Net List USD),

sum(PAS P1@Net Amount),

sum(PAS P1@Net Contra)

)

jonathandienst — Tue, 19 Sep 2017 09:26:48 GMT

You could try the dynamic expression:

=Sum([$(=COL)])

dolly777 — Tue, 19 Sep 2017 09:43:30 GMT

Thanks .. I tried this way and got the approximate value but not exact value

shraddha_g — Tue, 19 Sep 2017 09:46:27 GMT

can you share expected output n what you are getting with this code?