topic Re: Default selection for year in QlikView

Default selection for year

Nagaraju_KCS — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I am comparing with data last 2 years..

As per my data 2009 and 2010 (whatever last 2 years)

I have selections See below Selections...

By default i want to show like below image...(2009 and 2010 by default selections for that particular charts )

and third chart i want to show 2009+2010 sum of the data.

If i am select Division, category and ProductName for i want effect 2 charts

Years should be static for these particular charts. whatever last 2 years.

PFA,

Thanks in Advanvce..........

sunny_talwar — Wed, 02 Mar 2016 15:44:55 GMT

PFA attached

Nagaraju_KCS — Wed, 02 Mar 2016 15:58:46 GMT

Hi Sunil,

If i am select Division, category and ProductName not reflecting data in Second chart and

3rd chart also not effecting (2009+2010).

sunny_talwar — Wed, 02 Mar 2016 16:01:48 GMT

I didn't know you have alternate state. Bring all the objects to inherited state and it should work

sandeep_sarawgi — Wed, 02 Mar 2016 16:14:40 GMT

I have recently worked on a requirement like that. I don't suggest using Alternate State for this.

What you can do is obtain distinct years in script in a separate field YearSelect.

Feed that into a list box.

Define a variable vYearSelect to store if(isnull(GetFieldSelections(YearSelect)), max(YearSelect),GetFieldSelections(YearSelect))

Create a dimension (which you can hide) = if(Year=vYearSelect,Year). Choose the option to suppress when null.

Similarly for previous year table you would do

Define a variable vPriorYearSelect to store if(isnull(GetFieldSelections(YearSelect)), max(YearSelect)-1,GetFieldSelections(YearSelect)-1)

Create a dimension (which you can hide) = if(Year=vPriorYearSelect,Year). Choose the option to suppress when null.

Nagaraju_KCS — Wed, 02 Mar 2016 16:22:25 GMT

Thanks Sunny..

I have doubt, can we show selection in Year list box (2009 and 2010)

sunny_talwar — Wed, 02 Mar 2016 16:27:52 GMT

Here you go

Year listboxes are in alternate state now. rest everything in inherited state