topic Re: Total Count in QlikView

Total Count

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a set of raw data that Qlik has help me count to the final Reward for the purpose of an incentive.

TheSales aft mulitplier is using the sum<total<Agent Name..and so on.

The Reward is calculated using IF condition.

The challenge is how do i count the total Reward count by its category in another table eg, the total count of the 2 tickets winners and 1 ticket winner in a straight table.

The count I am referring to is 2 winners for 2 tickets and 3 winners for 1 ticket.

Agent name	Sales$	Sales$ aft multiplier	Reward
Agent A	21766	26766	2 tickets
Agent B	19099	24348	2 tickets
Agent C	15987	17874	1 ticket
Agent D	13488	16985	1 ticket
Agent E	12854	15098	1 ticket

Thanks,

Re: Total Count

jyothish8807 — Thu, 23 Nov 2017 06:56:38 GMT

Hi Mabel,

Can you please share the desire output you are expecting ? That will be helpful.

Br,

Re: Total Count

jyothish8807 — Thu, 23 Nov 2017 07:05:53 GMT

Hi Mabel,

You can do this very easy if you can create the reward calculation table in script.

For eg,

Load [Agent Name],

Sales$,

sum<total<Agent Name as [Sales$ aft multiplier],

if(condition) as Reward

from <>

Then at UI simply create a straight table:

Dimension: Reward

Exp: Count (reward)

Br,

Re: Total Count

jyothish8807 — Thu, 23 Nov 2017 07:08:51 GMT

Else try to create a calculated dimension:

Dim: aggr(Reward Claculation,Agent name)

Expresion: Count(aggr(Reward Claculation,Agent name)

Not sure if this will work.

Br,

Re: Total Count

woshua5550 — Thu, 23 Nov 2017 07:09:05 GMT

attach a sample app will make it easy to check

in my view,we have to know the expression of "Reward", make a little change on it and then use it as a calculated dimension