topic Chart should filter based on the current Year in QlikView

Chart should filter based on the current Year

Wed, 06 Mar 2013 06:45:46 GMT

Hi,

I have a requirement to display the chart based on the current year.

Ex: Assume i executed the document on March 2013, Line chart with X axis as Cyclic Group: Year>Month>Week. When i open the document i need to display the line chart based on the current year (2013) and further if i drill through to Month then the chart should display Jan, Feb, Mar data and if i further drill thru the week then it should display the week numbers based on the particular month.

Please let me know the solution. Thanks in Advance!!!

Thanks

Badri

Re: Chart should filter based on the current Year

alexandros17 — Wed, 06 Mar 2013 07:58:32 GMT

When you open a document you can use triggers (you find them in document properties -> triggers) then set the field (or variable) value to the current year value ....

Re: Chart should filter based on the current Year

Wed, 06 Mar 2013 11:47:48 GMT

Hi Alex,

In triggers i have set the field value to the current year, if i open the document the current year will display initially but in chart if i further drill down on month its showing previous year months data also but i need only the current year months data should display in chart.

Help in sorting out this problem.

Thanks

Badri

Re: Chart should filter based on the current Year

alexandros17 — Wed, 06 Mar 2013 12:17:30 GMT

I have to see the data cloud to solve the problem ...