Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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