Dynamic Column

[Karim_Khan]

How to apply the dynamic column(Month) in qlikview.So that value gets calculated on the basis of Month

[Anonymous]

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)

[rubenmarin]

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:

Qlik Community Tip: Posting Successful Discussion Threads