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: 
Not applicable

Correlation Chart

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

   

InvoiceDateItem NameInvoice Amount
2/20/2015Water20.75
2/21/2015Water21.75
2/22/2015Water22.75
2/23/2015Water23.75
2/24/2015Water68.11
2/20/2015Bread390
2/21/2015Bread520
2/22/2015Bread520
2/23/2015Bread520
2/24/2015Bread880
2/20/2015Milk2614.8
2/21/2015Milk2614.8
2/22/2015Milk2614.8
2/23/2015Milk2614.8
2/24/2015Milk2614.8
2/20/2015Cheese3268.5
2/21/2015Cheese3922.2
2/22/2015Cheese5229.6
2/23/2015Cheese7844.4
2/24/2015Cheese785.38

Please help.

10 Replies
Not applicable
Author

Thank you again for taking sometime to help others.