topic Bar chart (interview qstn) in QlikView

Bar chart (interview qstn)

Fri, 26 Sep 2014 04:45:05 GMT

Hi friends,

I face done interview Question on Bar Chart. I am unable to solve that question please help me.

The Question is:

1) How to display the current selected year data and at the same time the next 5 years data on bar chart ?

EX: I have 50 years of date like 1960 to 2010 . Then i select 2005 year then i go to display 2005 ,2006,2007,2008,2009,2010 data.

How it is ?how to display the only 5 years data in the bar chart. any expressions is there please conclude me.

PrashantSangle — Fri, 26 Sep 2014 04:51:22 GMT

Hi,

Use Year as dimension,

Expression become

Sum({<DateField={">=$(=Date(max(DateField)))<=$(=Date(AddYears(max(DateField),5)))"}>}sales)

Regards

sushil353 — Fri, 26 Sep 2014 04:52:05 GMT

Hi,

It is easy, Try below expression:

sum({<Year={">= $(=Max(Year)) <= $(=Max(Year)+5)"}>}value)

HTH

Sushil

SunilChauhan — Fri, 26 Sep 2014 05:06:30 GMT

see the attched

might helps