Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
rangesum(below(sum(saleS),3))
Hi Manoj,
it is only displaying the first 3 years sales.
But i need to display values related to selection made in slider object.
when u select 2000 then it shows 2001,2002,2003 sales
did u checked with any selections ?
Yes i have checked with the selections in slider but it is not working.
can u share some sample data
nenu try chesthunna ravatam la but i will do my level best narendra dhulipala
i am trying by loading sample data by inline loading
like
load * Inline
[
Year,Sales
2004,18899,
2005,17780,
2006,16666,
2007,99999,
2008,44444,
2009,78777
]
hi,
try this. Select Multiple Value in the slider object.
Regards,
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.