months as columns

[#1]

Hi All,

I want to show months as columns.

If month 1 is selected, then it should show columns as 1 and Q1(with data of only month1),

If month 2 is selected, then it should show columns as 1, 2 and Q1(with data of only month1 and 2),

If month 4 is selected, then it should show columns as 1, 2, 3, Q1(with data of month1,2,3), 4, Q2(with data of only 4) and similarly for other months.

Also I want to create this dynamic month column as dimension and then drag it above expressions to make it as columns using pivot table.

[muniyandi]

Hi Apurvapetkar,,

Pls Check My Attachment File.

Using Input Box Method..

I hope this helps!

By Muni

[jagan]

Hi,

Use Pivot table with Quarter and Month as dimensions and pivot this dimensions by dragging to top.  Now in your expression use as below

=Sum({<MonthFieldName={'<=$(=Max(MonthFieldName))'}>} Sales)

Now if you select 4 then automatically qlikview shows 4 months values in pivot table with their corresponding quarter.

Hope this helps you.

Regards,

jagan.

[marciomgm]

PERFECT! THANKS!