topic Re: Count in QlikView

Count

qlikviewaf — Thu, 12 Jul 2018 14:05:57 GMT

Hi, i have selected a specific value (ShipTo), where there are transaction just on day 8,15,22.

How i can get a count of the days selected regardless any selection done ? (e.g on the ship to)

I would like to get 28 days as possible days.

Thank you

qlikviewaf — Thu, 12 Jul 2018 14:23:40 GMT

I USED

=Day(MonthEnd(Date(Date#(GetFieldSelections(Month), 'MMM'))))

BUT THIS WORKS ONLY IF 1 MONTH IS SELECTED.

How i can have this working for multiple months ?

Thank you!

ogautier62 — Thu, 12 Jul 2018 14:28:37 GMT

Hi,

like this I think :

count({1<Month = $::Month>} distinct Day)

qlikviewaf — Thu, 12 Jul 2018 14:31:15 GMT

Hi Olivier, is not working.

ogautier62 — Thu, 12 Jul 2018 14:34:29 GMT

ok,

how is it working ? text box , graph ? what response does that give ?

qlikviewaf — Thu, 12 Jul 2018 14:41:13 GMT

it's working only if one month is selected, but if 2 are selected is not working. Any idea?

ogautier62 — Thu, 12 Jul 2018 14:46:31 GMT

I made a count in a text box, and that works;

is it a text box ? what result do you obtain ?

qlikviewaf — Thu, 12 Jul 2018 14:56:44 GMT

is a text box, look the screenshot. 2 month selected but still have 31

ogautier62 — Thu, 12 Jul 2018 15:03:35 GMT

and your expression exactly please ?

qlikviewaf — Thu, 12 Jul 2018 15:09:29 GMT

=count({1<Month = $::Month>} distinct Day)

this one

ogautier62 — Thu, 12 Jul 2018 15:15:56 GMT

sorry I understand,

Day is a number from 1 to 31 ? it's not a date ?

if it's a number,

use field date of your calendar and not Day