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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik4asif
Creator III
Creator III

How to pass variables in expressions when i am not using = symbol in variable declaration

I am aware of passing variables in expression when i give = in variable declaration

In Variable declaration

vMaxDate

=Max(Month)

Eg1-----  =If(Month>Date(AddMonths(vMaxDate,-12),'YYYY-MM') and YTD>0,DateMonth)

Eg2-----  =Num(Sum({<Region={'Global'},Month ={">$(=Date(AddMonths(vMaxDate,-12),'YYYY-MM')) <=$(vMaxDate)"}>} YTD), '##.##')

Eg3-----  ==Num(Sum({<Function={'XXXXX'},Month={'$(vMaxDate)'}>}YTD),'##.00')

Now my Question is how to write whe i have not included = symbol in variable declarartion

vMaxDate

Max(Month)


Thanks in advance

2 Replies
Anil_Babu_Samineni

Perhaps these?

If(Month>Date(AddMonths($(=vMaxDate),-12),'YYYY-MM') and YTD>0,DateMonth)

Num(Sum({<Region={'Global'},Month ={">$(=Date(AddMonths($(=vMaxDate),-12),'YYYY-MM')) <=$(=vMaxDate)"}>} YTD), '##.##')

Num(Sum({<Function={'XXXXX'},Month={'$(=vMaxDate)'}>}YTD),'##.00')

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
qlik4asif
Creator III
Creator III
Author

I have tried this but not working