Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have time series numeric data for all my sales items. I would like to correlate each item’s Invoice amount in that particular time period. I am able to correlate very easy in R (that may be because I am familiar with R
But cool thing with Qlik is ‘Interactive’ and I can pick and choose Water with Bread or Water with Milk or Milk with Cheese. In fact that is my requirement. My user want to pick and choose these items and would like to know correlation between those items.
Is this possible?
I found the similar solution Adrien Allard (130205_correlation.qvw) but not much luck with my data.
https://community.qlik.com/thread/84477
My sample Data
InvoiceDate | Item Name | Invoice Amount |
2/20/2015 | Water | 20.75 |
2/21/2015 | Water | 21.75 |
2/22/2015 | Water | 22.75 |
2/23/2015 | Water | 23.75 |
2/24/2015 | Water | 68.11 |
2/20/2015 | Bread | 390 |
2/21/2015 | Bread | 520 |
2/22/2015 | Bread | 520 |
2/23/2015 | Bread | 520 |
2/24/2015 | Bread | 880 |
2/20/2015 | Milk | 2614.8 |
2/21/2015 | Milk | 2614.8 |
2/22/2015 | Milk | 2614.8 |
2/23/2015 | Milk | 2614.8 |
2/24/2015 | Milk | 2614.8 |
2/20/2015 | Cheese | 3268.5 |
2/21/2015 | Cheese | 3922.2 |
2/22/2015 | Cheese | 5229.6 |
2/23/2015 | Cheese | 7844.4 |
2/24/2015 | Cheese | 785.38 |
Please help.
Thank you again for taking sometime to help others.