topic Re: Replication the chart based on selection in QlikView

Replication the chart based on selection

Tue, 16 Jul 2013 09:14:02 GMT

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

Re: Replication the chart based on selection

Tue, 16 Jul 2013 09:19:07 GMT

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

Re: Replication the chart based on selection

Tue, 16 Jul 2013 09:20:56 GMT

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?

Re: Replication the chart based on selection

Tue, 16 Jul 2013 09:27:04 GMT

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

Could you post any sample file?

Karthik

Re: Replication the chart based on selection

Tue, 16 Jul 2013 09:46:28 GMT

By using macro you can achieve it..

are you willing to write macro?

Re: Replication the chart based on selection

Tue, 16 Jul 2013 10:23:15 GMT

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

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

any help is appreciated..

thanks

Re: Replication the chart based on selection

Anonymous — Tue, 16 Jul 2013 10:52:50 GMT

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

Re: Replication the chart based on selection

Tue, 16 Jul 2013 13:27:28 GMT

again as i said..

i dont want multiple tables..

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

Re: Replication the chart based on selection

Anonymous — Tue, 16 Jul 2013 15:05:47 GMT

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