Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to pass the Max(Year) dynamically instead of statically(START_YEAR='2010' ). Any idea how to do the same?
I tried to pass $<START_YEAR={$(=Max(START_YEAR))}>} instead of START_YEAR='2010' but it didn't work. Please help me out
=ceil(sum(if( START_YEAR='2010' and wildmatch(Category,'*Call1*') > 0 and (wildmatch([Agreement Met],'no')>0),1,0)) /
sum(if(START_YEAR='2010' and wildmatch(Category,'*Call1*') > 0 ,1,0)) ,.01)
hi Attitude,
Tyr out the below expression
Sum({<Year={$(=Max(Year))}>} Sales )
Thanks Deepak
Samething I tried in my expression but it didn't work. Please check and let me know what shall be done for this. I know it is very simple only but some time even small things are very difficult in qlikview.
HI Attitude,
the Syntax which you have shown on top and what I added is different. There is a dollar sign difference.
It might be a small problem.
You can also check in the template What's New in QLikview 9.0.
I have taken the expression from the Dashboard tab and its working fine there.
HI Deepak,
I tried that by removing the $ sign also but still I didn't work. 🙂
We might have copied it from where it works but it should work inside this expression that is more important.
Can you attach you application. I can check and let you know on the same.
or else.
check what value are you getting in max(Year) and compare it with field, there might be a data mis match. Thats only i can think of now. If you can attach the application I will have a better view.
Sorry cannot attach the application! Please try to help me out without that
hi Attitude,
you can try out with if statement.
if(max(Year) = vYear , Sum(Amount)).
where vYear is the variable which contains vYear =max(Year).
But i still suggest the set analysis method.
if you can copy paste sample data for 2010 i can show you how it can be done.
Hi Attitude,
I am not clear on your logic since you are comparing the same column START_YEAR against START_YEAR. Are you looking forward as the expression should get calculated only for the maxium year ?
I am just trying to pass the Max(START_YEAR) in to the START_YEAR. Something like this START_YEAR='2011'. Hope it is clear now...