Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
stevejones1
Contributor III
Contributor III

Aggr and Sum for Bands

Here is my data :

Below is the aggregation of Gross pos by quarter , this for all the Products ,

I need to create  Bands based of Gross POS aggregated by each Product , so is the Gross POS for the Product is 3000$ it should fall under band"$1-$5000" so on ...

YearQuarterGross POS
2018Q4($11,192,392.54)
2019Q1

($4,053,867.10)

Expected Output :

Product Discount Band          2018Q4            2019Q1

1-5000                                    $0.54M             $4000000M

5001-10000                            $192.392M       $53867.10M

10001-20000                          $11.00M             0

20001-50000                          $0.00                  0

50001-100000                        $0.00                  0

Any help on how i can achieve this?Attached app

Thanks

2 Replies
shiveshsingh
Master
Master

Please try with calculated dimension.

Attach reduced app plz

qv_testing
Specialist II
Specialist II

Try this.....

Load *, IF(Salary<=5000, '0-5000',

IF(Salary>5000 and Salary<=10000, '5001-10000',

IF(Salary>10000 and Salary<=20000, '10001-20000',

IF(Salary>20000 and Salary<=50000, '20001-50000',

IF(Salary>50000 and Salary<=100000, '50001-100000'))))) as SalaryBand;

Please try to attach small application...