Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

EXPRESSION

Hi Friends

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

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

5 Replies
ashfaq_haseeb
Champion III
Champion III

Hi.

What is the definition of vNRP

May be try like this

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



Regards

ASHFAQ

upaliwije
Creator II
Creator II
Author

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
Not applicable

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
Master II
Master II

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

Best Regards,
KC
maxgro
MVP
MVP

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