topic Re: Month columns in QlikView

Month columns

Mon, 08 Apr 2013 06:13:29 GMT

Hi,

I have to create 3 Months as columns as per selected Month.

If I select Jan, it should show Jan Feb March as column.

for this, I have created Month as a column in dimension and on expressions side I have written expression as

sum({< Month = {'>=$(=(Max(Month))) <=$(=(Max(Month)+2))'}>} SalesValue)

This is working fine and it is showing correct months Jan Feb and March as columns.

But the problem is when I select month as Dec.

When I select Dec, it shows only Month as Dec, where as it should show Dec 2012, Jan 2013 and Feb 2013.

So how to accomplish it?

Re: Month columns

Wed, 17 Apr 2013 14:54:40 GMT

I found the solution for my problem.

I handled the scenario if selected month is Dec.

But now I have another problem.

Here I have pivoted Column1, Sub Column row and the last row.

so in short all the columns for values are pivoted.

Here the problem is for Amt and % column.

In the expression if I write as "if(SubSubCol = 'Amt', write the expression, 0)

But it is not working. all values are 0.

Please can any one help me on this issue?

If my approach to display data as per above format is incorrect, then please correct me in that case also.

Re: Month columns

khag_hs — Wed, 17 Apr 2013 15:23:43 GMT

Lade das Datum mal als "monthname". Normalerweise sollte dann der Monat mit Jahr angezeigt werden (evtl. muss das Monatsformat im Skript angepasst werden).

Wie sehen denn Deine Originaldaten aus?

Re: Month columns

khag_hs — Wed, 17 Apr 2013 15:23:50 GMT

Lade das Datum mal als "monthname". Normalerweise sollte dann der Monat mit Jahr angezeigt werden (evtl. muss das Monatsformat im Skript angepasst werden).

Wie sehen denn Deine Originaldaten aus?

Re: Month columns

khag_hs — Wed, 17 Apr 2013 15:24:03 GMT

Lade das Datum mal als "monthname". Normalerweise sollte dann der Monat mit Jahr angezeigt werden (evtl. muss das Monatsformat im Skript angepasst werden).

Wie sehen denn Deine Originaldaten aus?

Re: Month columns

Wed, 17 Apr 2013 15:54:12 GMT

try this - see attached

Re: Month columns

Thu, 18 Apr 2013 04:30:12 GMT

Thanks to both of you for the reply.

But you both replied to my earlier Q. The solution for which I found, displaying month with year solved my problem.

But now I have another problem.

Please can you check my 2nd post.

Re: Month columns

kaushiknsolanki — Thu, 18 Apr 2013 06:47:52 GMT

Hi,

This is because there is no selection in field SubSubCol.

This expression will work only if you select Amt in field SubSubCol.

post your application for more help and understanding of your data.

Regards,

Kaushik Solanki