Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

See this blog post: Calendar Chart | Qlikview Cookbook


talk is cheap, supply exceeds demand