topic Re: Count of Max Weekday Sales in QlikView

Count of Max Weekday Sales

Anonymous — Mon, 20 Oct 2014 20:56:24 GMT

Hi, hope somebody can help me. I would like to know how can I set the analysis expression in order to achieve the following:

I want to know the number of every day of the week in which the sales are the maximun value within the week and between a period, e.g. two months

Let's say we have the following data:

Week	Weekday	Sales
36	Monday	1000
36	Tuesday	500
36	Wednesday	800
36	Thursday	400
36	Friday	600
37	Monday	1500
37	Tuesday	800
37	Wednesday	700
37	Thursday	500
37	Friday	600
38	Monday	800
38	Tuesday	2000
38	Wednesday	1500
38	Thursday	800
38	Friday	600

So the result of this table is:

Week	WeekDay with the maximun Sales
36	Monday
37	Monday
38	Tuesday

What I want to get is the number (count) of every Weekday in which it has got the maximun value.

Weekday	Count
Monday	2
Tuesday	1

Thanks in advance

Re: Count of Max Weekday Sales

d_pranskus — Mon, 20 Oct 2014 23:16:17 GMT

Please take a look at the application attached.

Darius

Re: Count of Max Weekday Sales

jagan — Tue, 21 Oct 2014 04:03:29 GMT

Hi,

Try like this in script, then it would be easier in frontend

Data:

LOAD

If(Peek('Week') <> Week, 1, 0) AS MaxFlag

RESIDENT DataTemp

ORDER BY Week, Sales Desc;

For Table1:

Dimension : Week

Expression: Only{<MaxFlag={1}>} Weekday)

For Table2:

Dimension : Weekday

Expression: Count{<MaxFlag={1}>} Weekday)

Hope this helps you.

Regards,

Jagan.

Re: Count of Max Weekday Sales

Anonymous — Tue, 21 Oct 2014 05:29:24 GMT

Hi Darius, I haven't seen any file attached. Could you please try again?

Thank you

Re: Count of Max Weekday Sales

Anonymous — Tue, 21 Oct 2014 05:30:46 GMT

Sorry I was mistaken. I'll take a look!

Thanks

Re: Count of Max Weekday Sales

jyothish8807 — Tue, 21 Oct 2014 06:22:42 GMT

Hi Pitutiti,

Try this:

In Dimension:

Week

In expression:

=firstsortedvalue(Weekday,-Sales)

Yoe will get your first table.

Regards

Re: Count of Max Weekday Sales

Anonymous — Tue, 21 Oct 2014 06:29:55 GMT

Darius, your suggestion works pretty good for me.Thanks a lot you all for you time!!

Re: Count of Max Weekday Sales

jyothish8807 — Tue, 21 Oct 2014 06:31:11 GMT

Hi Pituti,

PFA

Regards