Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
May be use set analysis to restrict the data in those charts which need to be restricted.
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
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
Hi,
May be try this
Document Properties -> Triggers -> OnOpen -> Add Action -> Select In Field
Field : Your Month Field
Search String : =Date(Today(),'MMMM/YY')
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
Thanks you all !!
Can you help with the logic