Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
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
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
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
See this blog post: Calendar Chart | Qlikview Cookbook