Count

[qlikviewaf]

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]

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]

Hi,

like this I think :

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

[qlikviewaf]

Hi Olivier, is not working.

[ogautier62]

ok,

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

[qlikviewaf]

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

[ogautier62]

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

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

[qlikviewaf]

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

[ogautier62]

and your expression exactly please ?

[qlikviewaf]

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

this one