topic Re: Getting Days in a Month in QlikView

Getting Days in a Month

Harish7 — Tue, 24 Jan 2023 11:15:12 GMT

Hi all, i'm new to qlik

I want count of days in a month from starting of month to till yesterday in set analysis

For example, today is 24th January, i need count of days from 1/1/2023 to 1/23/2023

PrashantSangle — Tue, 24 Jan 2023 11:27:02 GMT

try simple

num(today())-num(monthstart(today()))

Regards,

Prashant Sangle

Harish7 — Tue, 24 Jan 2023 11:33:24 GMT

Thanks Prashant it is working, I'm using 'Date' dimension field, and i need it count function with set analysis...

MarcoWedel — Tue, 24 Jan 2023 18:35:14 GMT

This function returns an integer representing the day