Count On BASED ON DATE

qlikview979 · ‎2016-09-21

Hi EXperts,

My Dymention is "DATE"

EXPRESSION is :- count(NUMBER)

how can i get count baesd on date

Anil_Babu_Samineni · ‎2016-09-21

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

tresesco · ‎2016-09-21

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

jagan · ‎2016-09-21

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.

Related Topics