topic Re: Graph Dimension Limits in QlikView

Graph Dimension Limits

Wed, 01 Mar 2017 14:59:13 GMT

Hi All,

I Have a bar graph with the dimension "Year" and some filters in the Dashboard with the all years available.

I need to limit the years to appears in the graph to three, and If I select only one year in the same way I need show always three year.

Any suggestions to do this?

Thanks in advance.

Re: Graph Dimension Limits

Anil_Babu_Samineni — Wed, 01 Mar 2017 15:38:36 GMT

What are the three years you need to constant? Which year you are selecting and what are the years you want to do keep. How many years you have in document?

Re: Graph Dimension Limits

Wed, 01 Mar 2017 15:43:38 GMT

Now in the document I have 4 years, {2014, 2015, 2016 and 2017}. But this dimension will be increased.

I what be always three years in the graph, even when I select a year, i.e. Year = 2014. The result need to be {2014, 2015 and 2016} for Year = 2016 the result {2015, 2016, 2017} or something similar.

Re: Graph Dimension Limits

sunny_talwar — Wed, 01 Mar 2017 15:45:17 GMT

May be use set analysis to always show three years?

Re: Graph Dimension Limits

Anil_Babu_Samineni — Wed, 01 Mar 2017 15:51:08 GMT

As i understand, you may need Set analysis

sum({<Date = {">=$(=AddYears(Year, -3)) <=$(=max(Year))"} >} Sales)

Re: Graph Dimension Limits

sunny_talwar — Wed, 01 Mar 2017 15:54:05 GMT

Some corrections

Three years from selection. If 2014 is selected, this will show 2012, 2013, & 2014 (even if 2016 is the max year available)

Sum({<Year= {">=$(=Max(Year)-3)<=$(=Max(Year))"} >} Sales)

Will always show 2014, 2015, 2016 (again assuming max year in the application is 2016)

Sum({<Year= {">=$(=Max({1}Year)-3)<=$(=Max({1}Year))"} >} Sales)

Re: Graph Dimension Limits

Wed, 01 Mar 2017 16:02:23 GMT

stalwar1, with what kind of expression?

Because in the "Graph Properties " -> "Dimension Limits " I what to "show only" [3 Values] but isn't correct.

I already have some expressions.

Re: Graph Dimension Limits

Anil_Babu_Samineni — Wed, 01 Mar 2017 16:04:23 GMT

Yes, I am assuming he don't have Forecast year

Re: Graph Dimension Limits

sunny_talwar — Wed, 01 Mar 2017 16:09:59 GMT

Then how are you using this in your set analysis?

sum({<Date = {">=$(=AddYears(Year, -3)) <=$(=max(Year))"} >} Sales)

Re: Graph Dimension Limits

Anil_Babu_Samineni — Wed, 01 Mar 2017 16:14:12 GMT

Hahaha, Typo error. I am assuming he has Forecast Year data. But i even doubt about difference

Sum({<Year= {">=$(=Max({1}Year)-3)<=$(=Max({1}Year))"} >} Sales)

Sum({1<Year= {">=$(=Max(Year)-3)<=$(=Max(Year))"} >} Sales)