Need help showing the data in pivot table

[#1]

Hi All,

I need a help from you guys. I have attached the qlikview document and the image. I want the data to be show like the image. How can i do this?.

-Raghu.

[#2]

Asim,

When i saw your application it looks fine, but you mentioned only current month and previous month values in the Inline wizard. If i include for dec month values then it shows dec month values in the chart. How can i exclude the dec month from the chart.

Thanks,

Raghu.

[#3]

Asim,

What is the function to find the previous month first date from database? If i set that date a min then I would get the result.

-Raghu.

[#4]

Hi Raghu,

The MTD formulas come from master calendar as below:

 YearToDate(TempDate , 0, Month($(vToday)))*-1 AS Cal_MTD_Current,
 YearToDate(TempDate , -1, Month($(vToday)))*-1 AS Cal_MTD_Previous

[#5]

You can find the first date of the current month as below:

=IF(Cal_MTD_Current=1,min(PROCESSDATE))

You can find the first date of the previous month as below:

=IF(Cal_MTD_Current=0,min(PROCESSDATE))

[#6]

Asim,

Thanks for your help. Finally i got it in query. Now it will be easy for me to present the data in qlikview.

Thanks,

Raghu.