topic Month filter in QlikView

Month filter

Tue, 11 Aug 2015 09:04:44 GMT

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 — Tue, 11 Aug 2015 09:09:29 GMT

use Month(Today())

Anonymous — Tue, 11 Aug 2015 09:10:22 GMT

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 — Tue, 11 Aug 2015 09:20:40 GMT

Can you share sample date ,if possible ?

MayilVahanan — Tue, 11 Aug 2015 09:33:32 GMT

Try like this

In expression , you can use like

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

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

qlikviewwizard — Wed, 12 Aug 2015 06:33:41 GMT

Hi Please try this.

Month(Today())