Count On BASED ON DATE

[qlikview979]

Hi EXperts,

My Dymention is "DATE"

EXPRESSION is :- count(NUMBER)

how can i get count baesd on date

[Anil_Babu_Samineni]

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

Count(DISTINCT Number)

OR

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

[tresB]

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

[jagan]

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.