topic Re: How to show data for the current month only? in QlikView

How to show data for the current month only?

Wed, 11 Nov 2015 15:07:46 GMT

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 — Wed, 11 Nov 2015 15:13:15 GMT

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

johnca — Wed, 11 Nov 2015 15:13:45 GMT

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

Wed, 11 Nov 2015 15:31:03 GMT

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 — Wed, 11 Nov 2015 16:13:51 GMT

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 — Wed, 11 Nov 2015 16:19:59 GMT

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

Wed, 11 Nov 2015 17:08:21 GMT

Thanks you all !!

arpita — Mon, 14 Dec 2020 17:20:03 GMT

Can you help with the logic