Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

3 levels division in set analysis.

Hi,

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

Re: 3 levels division in set analysis.

Hi Pankaj,

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

Not applicable

Re: 3 levels division in set analysis.

Hi,

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

Re: 3 levels division in set analysis.

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

Not applicable

Re: Re: 3 levels division in set analysis.

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.