How to show data for the current month only?

[#1]

Hello everyone,

I need to create a rule that shows data for the current month only, in some charts of my sheet.

The field of date of my data base is like that:

Anyone could help me to set this rule on QlikView?

Thanks

[sunny_talwar]

May be use set analysis to restrict the data in those charts which need to be restricted.

[johnca]

Hi Rodrigo,

I would set a flag in the script for the current month;

If(MonthStart(YourDateField)= MonthStart(Today()),1,0) as CurrentMonth

Then call it in your chart

Sum({<CurrentMonth={1}>}YourDataField)

--john

[#4]

Thanks John, it worked.

But when i select from the month filter another month, no data is displayed.

I need that rule only in the first view, when the user open the dashboard.

How can i set the current month on the open trigger?

Thanks

[settu_periasamy]

Hi,

May be try this

Document Properties -> Triggers -> OnOpen -> Add Action -> Select In Field

Field : Your Month Field

Search String :  =Date(Today(),'MMMM/YY')

[johnca · Accepted solution]

Okay, so you need it to be dynamic. I would create a month field based on your data field in the script

MonthStart(YourDateField) as Month

Then maybe the expression would be

Sum({<Month={$(=Max(Month))}>}YourDataField)

--john

[#7]

Thanks you all !!

[arpita]

Can you help with the logic