topic Re: Quarters data in set analysis? in QlikView

Quarters data in set analysis?

skumarqv11 — Wed, 25 Jan 2017 12:01:31 GMT

Hi Folks,

I have my data like below.for each quarter we have the sales.and in the master calender also i have only quarter dates(i.e only 5 YearMonths)

I need a output for Each month i want to show the data like below. i am creating 5 expressions for each yearmonth but its not working fine.

Please Suggest me the approach???

sunny_talwar — Wed, 25 Jan 2017 12:37:26 GMT

May be use a Pivot table?

krishna20 — Wed, 25 Jan 2017 12:43:53 GMT

can you please provide same sample data

Thanks

rahulpawarb — Wed, 25 Jan 2017 12:56:23 GMT

Hello Shravan,

I agree with Sunny! However, please share some sample data/script you used, if possible. This will help us to further analyze this issue.

Regards!

Rahul