topic Re: Default to data to current Year in QlikView

Default to data to current Year

Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

Am new to qlikview. Am looking to default data in one of the 5 reports in a tab to only current year. There is year filter given where it changes dynamically if user selects .

I tried doing this. Year(date dim)=year(today()).Its not working

Re: Default to data to current Year

sunny_talwar — Thu, 16 Mar 2017 16:33:02 GMT

Use set analysis may be, but before you do that, create a Year field in the script

LOAD DateField,

Year(DateField) as YearField

...

From ...;

and now use this

{<YearField = {$(=Year(Today())}>}

Re: Default to data to current Year

Anonymous — Fri, 17 Mar 2017 05:21:57 GMT

Hello Madhu J

Do you want that report to always show current year data as default? Once you use set analysis data in that report will not be associated with any selections in your filter.

Thanks & Regards

Chintan

Re: Default to data to current Year

rahulpawarb — Fri, 17 Mar 2017 05:42:14 GMT

Hello Madhu,

Trust that you are doing good!

Please follow below steps to fix the problem:

1. Open the Document Properties (Ctrl + Alt + D) and locate Triggers tab

2. Select OnOpen option under Document Event Triggers and press Add Action(s)... button

3. This will popup Actions window. Press Add button.

4. Set Selection as Action Type and Select in Field As Actions

5. Mention the field you want to set i.e. [Current Year] and mention =Year(Today()) in Search String

5. Click ok to save the changes

6. Change the [Current Year] filter to different year than current, save the document and close the document

7. Once again open the document and you will see Current Year set as filter

Hope this will be helpful.

Regards!

Rahul

Re: Default to data to current Year

Fri, 17 Mar 2017 10:53:39 GMT

Thank You for replying.

Can we do this without using set analysis. Only when dashboard page opens at first it , current year data should be populated else it should be dynamically changes according to filter selected. Using triggers is effecting whole tab.Can this be achieved for a single report.

Re: Default to data to current Year

sunny_talwar — Fri, 17 Mar 2017 10:55:14 GMT

You can use on open trigger in that case

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Document_Properties_Triggers.htm