topic Re: Expression on Counting in QlikView

Expression on Counting

Tue, 21 Jul 2015 01:40:39 GMT

Hi QlikCommunity,

Can someone help me what expression should I use to count the Owner who has penalty per Quarter.

I will attached the data needed in for this problem.

Thanks in advance. Please help me

Re: Expression on Counting

sunny_talwar — Tue, 21 Jul 2015 02:20:50 GMT

What is the expected output from the file you have shared?

Re: Expression on Counting

Tue, 21 Jul 2015 02:42:58 GMT

Good day sunindia,

I'm expecting an output of total count the owner who has penalty per year and per quarter.

Thanks in Advance

Re: Expression on Counting

sunny_talwar — Tue, 21 Jul 2015 02:50:32 GMT

Numerically what is the number you are expecting to see?

Re: Expression on Counting

Tue, 21 Jul 2015 02:56:55 GMT

in year 2013 and 2014 there must be 1 owner and in per quarter of 2013 there must be 1 per quarter, while in the 2014 quarter, only quarter 1 to 3 should have 1 and in quarter 4 there must be 0.

Re: Expression on Counting

qlikviewwizard — Tue, 21 Jul 2015 03:36:58 GMT

Hi imlesterrawr

Could you update the excel file and attach again with your required output?

Re: Expression on Counting

Tue, 21 Jul 2015 03:46:38 GMT

Hi Mr. Wizard

Where is the attach button in reply section? i cant find it.
The output I need to see is the total count of owner who has penalty per year and per quarter.

can you do that with your awesome magic Mr.Wizard?

Re: Expression on Counting

jagan — Tue, 21 Jul 2015 04:36:39 GMT

Hi,

Try like this

Chart : Pivot Table

Dimension: Year1, Qtr1

Expression: =Count({<penalty={'>0'}>}DISTINCT owner)

You will get the required output.

Regards,

Jagan.

Re: Expression on Counting

jagan — Tue, 21 Jul 2015 04:37:25 GMT

PFA file for solution.

Regards,

jagan.

Re: Expression on Counting

_rohitgharat — Tue, 21 Jul 2015 05:13:29 GMT

hiii Lester,

As per your question i think you will have to make Penalty flag i.e you have to consider penalty greater than 0

and expresion would be:

count({<PenaltyFlag={"1"},year={"$(=vMaxYear)"},quarter={"$(=vMaxqtr)"}>} distinct owner)

Thanks,

Rohit

Re: Expression on Counting

Tue, 21 Jul 2015 05:52:07 GMT

(penalty>0,count(aggr(count(distinct owner),qtr1,year1)),0)

Re: Expression on Counting

Tue, 21 Jul 2015 06:25:03 GMT

Thanks for the help sir

Re: Expression on Counting

jagan — Tue, 21 Jul 2015 06:28:01 GMT

Its my pleasure to help you.

Regards,

Jagan.