Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hari8088
Creator
Creator

Output data should in Calender format

Hi Experts,

I have one scenario which i am not able to get output.

please refer attached excel.

Sheet1 is my input and in sheet2 i have given my output format.

expression is sum(data)/sum(data1).

For example when i choose Jan-2017 the output should be

 

SunMonTueWedThuFriSat
97%97%97%97%97%97%97%
97%97%97%97%97%97%97%
97%97%97%97%97%97%97%
97%97%97%97%97%97%97%
97%97%97%

Because jan-2017 month first start from Sun same way when i choose Feb-2017 output should be

 

SunMonTueWedThuFriSat
97%97%97%97%
97%97%97%97%97%97%97%
97%97%98%98%98%98%98%
98%98%98%98%98%98%98%
98%98%

98%

Thanks in advance

2 Replies
devarasu07
Master II
Master II

Hi,

Try like this, Thanks

Calendar View | Qlik Freak

Hope this helps to you

Regards,
Deva

Gysbert_Wassenaar

See this blog post: Calendar Chart | Qlikview Cookbook


talk is cheap, supply exceeds demand