Help on adding sumif equivalent columns to data table in script

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I have a data table below:

Customer	Product	Month	Year	Duration	Age	Gender
12345	01	03	2016	1	50	F
23465	01	03	2016	2	40	M
12654	01	03	2016	4	50	F
13546	02	03	2016	5	20	F
16544	02	03	2016	7	45	M

I want to calculate number and percentages of customers based on issue month/year and duration.

For example:

5 customer bought products in 3/2016 that has duration of 1 or longer

3 customer bought products in 3/2016 that has duration of 4 or longer

3 out of 5 customers with durations 4 or longer = 60%

As duration increase, percentages should decrease.

Duration	count	percentage
1	5	100%
2	4	80%
3	3	60%
4	3	60%

I try using duration as dimension and calculate the percentages in expression. But since denominator is calculated using all duration, it doesn't work..

I'm really new at this, any help would be great!!!

Thanks!

Re: Help on adding sumif equivalent columns to data table in script

sunny_talwar — Thu, 27 Oct 2016 20:35:53 GMT

May be like this for denominator:

Count(DISTINCT TOTAL Customer)

Count(DISTINCT TOTAL <Month, Year> Customer)

topic Re: Help on adding sumif equivalent columns to data table in script in QlikView

Help on adding sumif equivalent columns to data table in script

Re: Help on adding sumif equivalent columns to data table in script