Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

3 levels division in set analysis.


I have maintained 1 more column in excel with N or D

and wrote the expression as sum({ Divisor = {'N'} >} Amt)/ sum({< Divisor = {'D'} >} Amt)

and this is working fine.

But now I want 3 levels of division. eg.: a/b/c

How to do this?Administrator

4 Replies
Not applicable

Hi Pankaj,

Not clear. Please explain little more what you are expecting.

Not applicable


I have to do division using set analysis, but the division is 3 levels.

like sum({ Divisor = {'N'} >} Amt)/ sum({< Divisor = {'D'} >} Amt)/ sum({< Divisor = {'D'} >} Amt1)

but which will be numerator and which is denominator is mentioned in my excel.

and also for some rows I have to just do 2 levels of division and for some rows 3 levels.

Not applicable

Can you please share some mock data and example, may be i can help you.

Not applicable

I have attached 3 files.

1. Data file containing sample data.

2. Particulars file which is used to link data in DB using interval range.

3. Qvw file

if you check the particluars.xls, as per that I have to do division of row1/row2/row3.