Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to apply the dynamic column(Month) in qlikview.So that value gets calculated on the basis of Month
Hi Karim,
You can use a variable. Call it vMaxMonth or whatever you want. The value for this should be the max month. So you would have something like:
=Max(Month)
Hi Karim, not sure to understand but in example, if you have a Month field in number format you can get the values for current month using set analysis:
Sum({<Month={'$(=Num(Month(Today())))'}>} Values)
And this post will help you to post questions and make easier for others to answer your questions: