topic months as columns in QlikView

months as columns

Wed, 02 May 2012 06:54:15 GMT

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.

Re: months as columns

muniyandi — Wed, 02 May 2012 11:14:26 GMT

Hi Apurvapetkar,,

Pls Check My Attachment File.

Using Input Box Method..

I hope this helps!

By Muni

months as columns

jagan — Wed, 02 May 2012 11:42:28 GMT

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.

Re: months as columns

marciomgm — Tue, 05 Feb 2019 09:24:31 GMT

PERFECT! THANKS!