topic Re: Results frequency in QlikView

Results frequency

claudio_reis_we — Sun, 28 Aug 2016 12:26:37 GMT

Hi,

Can you help me please!

In the example below I am counting the item per store and date. I would also like to know the frequency of income per store.

Table:

store | date | item

1 | 01/08/2016 | A

1 | 02/08/2016 | A

1 | 03/08/2016 | A

Max(Aggr(Count(DISTINCT item),store,date))

Result:

store | amount | frequency

1 | 2 | ???

Question: what is the frequency?

Re: Results frequency

sunny_talwar — Sun, 28 Aug 2016 15:22:29 GMT

What are you expecting to see for frequency and why?

Re: Results frequency

claudio_reis_we — Sun, 28 Aug 2016 16:50:24 GMT

Hi Sunny, thank you for your quick response.

I would like to represent the frequency in which store worked with the maximum number of cashiers. Follow attached the example for your better understanding.

Thank you in advanced.

Qty cashier = Max(Aggr(Count(DISTINCT ID_Cashier),Store,Date))

Re: Results frequency

sunny_talwar — Sun, 28 Aug 2016 20:06:59 GMT

I see what you are looking to get, would you be able to share a sample to play around with it. Apologize for not able to give you a solution right away, as I feel I might need to play around with it before I can propose a solution

Re: Results frequency

effinty2112 — Sun, 28 Aug 2016 20:36:02 GMT

Hi Claudio,

See if

Count(if(Aggr(Rank([Qty Cashier],1,1)=1,Store,Date),1))

gives you what you want.

Cheers

Andrew

Re: Results frequency

claudio_reis_we — Mon, 29 Aug 2016 14:55:52 GMT

Hi Sunny,

Follow the file for your analysis.

Thanks

Re: Results frequency

claudio_reis_we — Mon, 29 Aug 2016 15:06:21 GMT

Hi Andrew,

This expression works only if the values have not been calculated. In this case, it has expression:

Qty cashier = Max(Aggr(Count(DISTINCT ID_Cashier),Store,Date))

Follow the file for your analysis.

Thanks

Re: Results frequency

effinty2112 — Mon, 29 Aug 2016 16:05:05 GMT

Try:

store	count(Aggr(if(Rank(Count(distinct id_cashier),1,1)=1,1),store,date))
12	6
1004	29
1404	1

Re: Results frequency

claudio_reis_we — Mon, 29 Aug 2016 17:43:32 GMT

Andrew,

Thanks so much, It worked.