Replication the chart based on selection

[#1]

hi all...

i am having 3 years sales data. I want that if i select one year from the check box for year, then the data for that year shouuld come.

Also if i select more than one year then the entire format should replicate and the data for all the yeears selected should come in separate tables with the same format.

how can this be accomplished in qlikview.

Please refer the image attached in which currently year 1994 is selected and the data for it is displayed.

now i want that when i select 1995 (2 years ie 1994 and 1995 are selected now), it should replicate the entire table and the data for 1995 should come in another table just beneath the 1994 table

[#2]

So you want to show as 3 different chart, if 3 years are selected..

Then you can create 3 different charts and In layout  show/conditional , write expression like

Chart1

Year='1994'

Chart2

Year='1995'.. like this

[#3]

thanks karthik..

but this is feasible only when i have just 3 years..

in case if i have more years data(say 50 years) then what?

[#4]

did  you try with simply pivot table. Subtotal based on year..

Could you post any sample file?

Karthik

[#5]

By using macro you can achieve it..

are you willing to write macro?

[#6]

no karthik.. can you please suggest something else..

i also dont have any sample regarding the same...

any help is appreciated..

thanks

[Anonymous]

You can create the same table multiple times and have Show conditons on the tables that test for count(distinct year)=1, 2, 3 etc.

In the expressions of this table you can test that Year=$(=max(Year)-1)  ... -2, -3, -4 etc.

Three problems with this are:

1. You have to maintain multiple tables

2. You have to set the height of each table, so a scroll bar will appear if taller than expected

3. You have to know what your limit of years and tables will be

Jonathan

[#8]

again as i said..

i dont want multiple tables..

isnt dre anything like Grouping in qlikview??( just like we have Grouping in Transact SQL)

[Anonymous]

Ah, I didn't look through all the previous comments.

What about Karthik's suggestion of adding as the highest level dimension in a pivot table ?

Jonathan