topic Re: Count On BASED ON DATE in QlikView

Count On BASED ON DATE

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

Hi EXperts,

My Dymention is "DATE"

EXPRESSION is :- count(NUMBER)

how can i get count baesd on date

Re: Count On BASED ON DATE

Anil_Babu_Samineni — Wed, 21 Sep 2016 08:22:46 GMT

You are correct, If you don't want to repeat dates then use, For ref, please use attachment

Count(DISTINCT Number)

Count({<Date = P(Date)>}Number)

Re: Count On BASED ON DATE

tresB — Wed, 21 Sep 2016 08:24:33 GMT

Your chart itself should return count based on date. Could you explain the issue with a sample qvw to look into?

Re: Count On BASED ON DATE

jagan — Wed, 21 Sep 2016 08:25:23 GMT

Hi,

Is there any relation between your INVOICE_DATE and NUMBER? Can you attach sample data? If Date and number fields are linked and data is at Date level then you will get by date.

Regards,

jagan.