topic Dynamic Column in QlikView

Dynamic Column

Karim_Khan — Tue, 21 Jul 2015 11:57:48 GMT

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

Re: Dynamic Column

Anonymous — Tue, 21 Jul 2015 12:04:54 GMT

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)

Re: Dynamic Column

rubenmarin — Tue, 21 Jul 2015 12:11:52 GMT

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