Expression on Counting

[#1]

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

[sunny_talwar]

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

[#3]

Good day sunindia,

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

Thanks in Advance

[sunny_talwar]

Numerically what is the number you are expecting to see?

[#5]

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.

[qlikviewwizard]

Hi imlesterrawr

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

[#7]

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?

[jagan · Accepted solution]

Hi,

Try like this

Chart : Pivot Table

Dimension: Year1, Qtr1

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

You will get the required output.

Regards,

Jagan.

[jagan]

PFA file for solution.

Regards,

jagan.

[_rohitgharat]

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