topic Re: how to write the expression to get dynamic chart in QlikView

how to write the expression to get dynamic chart

sonysree88 — Sat, 16 Nov 2024 21:31:42 GMT

Hi All,

I have one filed that Year: 2000

2001,

2002

2003

...

and so on 2010

Based on the user selection previous years data needs to be displayed.

for example: user selects 2003 so it needs to be displayed the previous years data means 2001 and 2002 data should get displayed.

if user selects 2006 , needs to get displayed 2001 to 2005 data not all , only the previous years data based on selection

Can you please help me on it.

uacg0009 — Mon, 28 Jan 2019 06:36:10 GMT

Hi,
1.When user select 2003, only show 2001, 2002? no 2003?
2.When user select 2006, only show 2001 to 2005? no 2006?

3.If user select more than 1 year, like 2003 and 2004, or 2003 and 2006, what year should be show?

Aiolos Zhao

Anil_Babu_Samineni — Mon, 28 Jan 2019 06:38:36 GMT

PFA

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

agni_gold — Mon, 28 Jan 2019 06:40:13 GMT

Please find sample app , and below expression will help you

sum({<Year={">=$(=min({1}Year)) <$(=GetFieldSelections(Year))"}>}Amount)

sonysree88 — Mon, 28 Jan 2019 06:43:55 GMT

Hi ,

If user select more than 1 year, like 2003 and 2004, or 2003 and 2006, what year should be show?

..If user selects 2003 and 2004--only 2001 , 2002 for 2003 selection and 2001,2002,2003 for 2014 selection

agni_gold — Mon, 28 Jan 2019 06:49:09 GMT

i would say , if user select more than one year , please show min to max data .

if 2003 and 2006 selected then show from 2003 to 2006

anushree1 — Mon, 28 Jan 2019 07:43:07 GMT

Please check if this works