Month filter

[#1]

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

[ecolomer]

use Month(Today())

[Anonymous]

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]

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)

[qlikviewwizard]

Hi Please try this.

Month(Today())