topic Re: EXPRESSION in QlikView

EXPRESSION

upaliwije — Sun, 21 Sep 2014 09:35:45 GMT

Hi Friends

Can someone please tell me why is the following expression not working in my pivot table ?

SUM({<DAYS_LEFT={">0"}>}$(vNRP))

ashfaq_haseeb — Sun, 21 Sep 2014 09:42:52 GMT

Hi.

What is the definition of vNRP

May be try like this

SUM({<DAYS_LEFT={">0"}>}(vNRP))

Regards

ASHFAQ

upaliwije — Sun, 21 Sep 2014 10:18:04 GMT

Thanks Asfhaq

What u suggest does not work

but when I write $(vNRP) in the expression it works

vNRP=SUM(PREMIUM)-(SUM({$<REINSURER-={'RI FUND'}>}RI_PREMIUM))+SUM({$<REINSURER-={'RI FUND'}>}RI_COMM)-SUM(COMM)

Pls check and help

Anonymous — Sun, 21 Sep 2014 10:46:45 GMT

make sure your filter DAYS_LEFT={">0"} returns any data, you can test with DAYS_LEFT in the dimension and $(vNRP) in the expression

jyothish8807 — Sun, 21 Sep 2014 10:49:30 GMT

Hi Upali,

Try the same expression in a straight chart and check whether its working or not.

SUM({<DAYS_LEFT={">0"}>}$(vNRP))

Regards

Jyothish KC

maxgro — Sun, 21 Sep 2014 16:04:36 GMT

remove the label of the expression with SUM .... in the pivot table

hover your mouse over the label and let we know what you see