Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Variable

Hi,

I need to create an dynamic variable which need to show sum(data) for only 1st of every month which would starts from FEB 2016.

Like sum(sales) where date = 03/01/2016(Mar),04/01/2016(Apr),......

Thanks..

6 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps like this: sum({<date={"=Day(date)=1"}>}sales)


talk is cheap, supply exceeds demand
nareshthavidishetty
Creator III
Creator III
Author

Hi,

I have used the below logic but it is giving value.But here i need for all the months where yearstart = Feb 2016.

sum({<[Reported Date]={"=Day([Reported Date])=1"}>}[Invoice Total Line Amt])

Thanks..

vishsaggi
Champion III
Champion III

Can you send us the screen shot of your expected output.? Or issue you are having. Gysbert's expression should give you the 1st of every month.

nareshthavidishetty
Creator III
Creator III
Author

Hi Gysbert,

Can i have the same logic instead of month start to month end.

Thanks..

sunny_talwar

Something like this:

Sum({<[Reported Date] = {"=Day([Reported Date])=Day(MonthEnd([Reported Date]))"}>} [Invoice Total Line Amt])

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

What logic? What do you mean 'month start to month end'? Which month for example?


talk is cheap, supply exceeds demand