Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Month filter

Hello All,

I have a table where I need to pull the data for the month. I am actually using a filter but I need to make the table dynamic.

In my load script I convert the date field into month as follows:

Month(Floor(CallUniversalTime)) AS Mois,

Do you guys have an expression which I can use in my Dimension to pull the data of the current month only.

Thanks,

Hasvine

5 Replies
ecolomer
Master II
Master II

use Month(Today())

Anonymous
Not applicable
Author

try

if (Month(Floor(CallUniversalTime))=Month(today()), Month(Floor(CallUniversalTime)) AS Mois

But the condition also Comes tru for same months in previous years

(now we have August, condition Comes tru for data fromaugust 2014 as well)

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Can you share sample date ,if possible ?

MayilVahanan

Hi

Try like this

In expression , you can use like

=Sum({<Month = {$(=Month(Today()))}>}yourExpression)

or

=Sum({<Month = {$(=Month(Today()))}, Year= {$(=Max(Year))}>}yourExpression)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
qlikviewwizard
Master II
Master II

Hi Please try this.

Month(Today())