Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Expression

Hi Friends

I have created a variable for the Risk Day which is as follows

vh1=(RISK_DAY>=1 and RISK_DAY<=14)

Now I want to apply this vh1 to expression which is follows

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY=$(v1h)>}Nos)

But this expression does not show the required results. Pls correct my expression

11 Replies
Anil_Babu_Samineni

I think this?

=sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY = {">=1 <=14" } >}Nos) // Try to check Single Quotes too


Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
upaliwije
Creator II
Creator II
Author

Hi Anil

Your expression too works as well