topic Re: Displaying Dimension values corresponding to selections made in slider object. in QlikView

Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 12:41:00 GMT

Hi,

I am new to qlikview. I have a question,

i have Year dimension and expression as sum(sales),and a slider object with the year field.

i have a requirement that when i select a year in slider object then the bar chart should display the sales of 3 years next to the selected year in the slider object.

Thanks

Nani.

Re: Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 12:48:58 GMT

try this

rangesum(below(sum(saleS),3))

Re: Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 12:52:09 GMT

Hi Manoj,

it is only displaying the first 3 years sales.

But i need to display values related to selection made in slider object.

Re: Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 12:54:16 GMT

when u select 2000 then it shows 2001,2002,2003 sales

did u checked with any selections ?

Re: Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 12:57:13 GMT

Yes i have checked with the selections in slider but it is not working.

Re: Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 13:02:01 GMT

can u share some sample data

nenu try chesthunna ravatam la but i will do my level best narendra dhulipala

Re: Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 13:09:01 GMT

i am trying by loading sample data by inline loading

load * Inline

[

Year,Sales

2004,18899,

2005,17780,

2006,16666,

2007,99999,

2008,44444,

2009,78777

]

Re: Displaying Dimension values corresponding to selections made in slider object.

sorrakis01 — Mon, 10 Nov 2014 13:19:51 GMT

hi,

try this. Select Multiple Value in the slider object.

Regards,

Re: Displaying Dimension values corresponding to selections made in slider object.

Mon, 10 Nov 2014 13:27:46 GMT

Hi Sorrakis01,

That is not my requirement,

My requirement is that when i select a year in slider object then the bar chart should display the sales of 3 years next to the selected year in the slider object.