topic Re: Count with Aggr in Front-end expression in QlikView

Count with Aggr in Front-end expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Any one help me to solve below issue

I want Count of ID field as final output in Front end expression by using ID, Indicator and Generatedflag. No change on count by selections (static).

jonathandienst — Mon, 03 Apr 2017 04:57:55 GMT

I suggest you give some examples of what output you require.

Anil_Babu_Samineni — Mon, 03 Apr 2017 04:59:44 GMT

What was the logic behind of Count ID. I am not getting as you expected. I've tried many times.

Count({<Generatedflag = {'No'}, Converted = {'Yes'}>} TOTAL ID)

Mon, 03 Apr 2017 07:51:48 GMT

Hi All - Thanks For Responding

My Requirement is:

Case1: If ID having indicator 1Y and 1N distinct Count of ID = 2 --->EX ID 123 (with out distinct count of ID =2)

Case2: If ID having indicator 1Y and >1N distinct Count of ID = 2 --->EX ID 124 (with out distinct count of ID =3)

Case3: If ID having indicator 1N and no Y distinct Count of ID = 1 --->EX ID 125 (with out distinct count of ID=1)

Case4: If ID having indicator >1N and no Y distinct Count of ID = 1 --->EX ID 127 (with out distinct count of ID=3)

Case5: If ID having indicator 1Y no N distinct Count of ID = 1 --->EX ID 130 (with out distinct count of ID =1)

Required this in Set Expression.

sunny_talwar — Mon, 03 Apr 2017 08:52:40 GMT

May be this:

Count({1} DISTINCT TOTAL <ID> Indicator&Converted&Generatedflag)