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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do expressions for set analysis depends on parameters?

Hi,

I need help guys, I got problems in creating set analysis for the following:

DATE
ITEM
AMOUNT
11/20/2012HTC25555
11/22/2012SAMSUNG26800
11/24/2012IPHONE4S35400
11/30/2012IPHONE4S34758
12/15/2012SAMSUNG24390
12/20/2012HTC25525
12/25/2012IPHONE549899
12/30/2012HTC25500
1/2/2013HTC30200
1/4/2013SAMSUNG28930
1/5/2013HTC12360
1/9/2013IPHONE4S34500
1/20/2013SAMSUNG24333
1/23/2013IPHONE4S32330

SET ANALYSIS FOR EACH ITEMS (TOTAL SALES)

1) This Year

2) Last Year

3) Year-to-date

4) Last-Year-to-date

5) This Month

6) Last Month

Thanks,

Bill

0 Replies