topic Re: Prob regarding chart in QlikView

Prob regarding chart

nikhilgarg — Tue, 17 Mar 2015 10:23:39 GMT

Hey,

I just gone thru a dashboard and wanted to make same. I have 4 buttons for(straight table , pivot table , bar chart , line chart).

Now, I want a single chart where if i select pivot table then it show pivot table. If i select Straight table function then it should show Straight table data and so on. By default Straight table data is shown.

Note: I must have only one chart where all this data is to be show. How can i do this ??

Re: Prob regarding chart

arulsettu — Tue, 17 Mar 2015 10:26:02 GMT

have you tried fast type change in chart

Re: Prob regarding chart

nikhilgarg — Tue, 17 Mar 2015 10:27:54 GMT

Hey,

Actually , this is to be attained other than fast type change.

Re: Prob regarding chart

arulsettu — Tue, 17 Mar 2015 10:29:32 GMT

then create four chart based on conditional show hide the charts and display

Re: Prob regarding chart

Tue, 17 Mar 2015 10:31:23 GMT

Hi,

First create a variable and assign value 1.

create 4 buttons and and add triggers on each button with the below values:

button for Straight table = assign 1 to variable

button for pivot table = assign 2 to variable

button for bar chart = assign 3 to variable

button for line chart = assign 4 to variable

Use the Show condition option under Layout of each object by checking variable = * (1/2/3/4).

Re: Prob regarding chart

nikhilgarg — Tue, 17 Mar 2015 11:52:10 GMT

Hey thanx but i see there is single chart and for each chart i select , let say for straight table , under Show Conditional in LAyout tab, vAdhoc = 1 is written , similarly for pivot it is =2 and so on. So any other way to acheive this ?

Re: Prob regarding chart

buzzy996 — Tue, 17 Mar 2015 11:56:44 GMT

u can try any of these ways,

1.container objects may help.

2, create variable and use this layout tab show conditional

if variable =1 straight table

variable =2 pivot table

variable =3 line table

variable =4 bar table

use pre-defined list box to select which ever u want.

Re: Prob regarding chart

jonathandienst — Tue, 17 Mar 2015 12:03:58 GMT

The way to do this with a single chart is the built in fast change functionality. There is no button action to perform the fast change, but you may be able to do it with a macro - but why would you want to write a macro to perform something that is already built in?

Alternatively, go with the multi-chart options suggested above.

HTH

Jonathan

Re: Prob regarding chart

Tue, 17 Mar 2015 12:13:47 GMT

Hi,

Stept 1: Directly can put in the container.

Step 2: create the 4 text objects and then connect the each text object with the each one charts by using 'set variable' in actions.

Tect Object:

Charts:

Example:

Text Object In set variable: Charts In conditional:

Text Object 1. vName, someName Straight table: =vName='someName'

Text Object 2. vName1, someName2 pivot table: =vName2= 'someName2'

Text Object 3. vName3, someName3 Straight table: =vName3='someName3'

Text Object 4. vName4, someName4 pivot table: =vName4= 'someName4'

Re: Prob regarding chart

nikhilgarg — Tue, 17 Mar 2015 12:18:34 GMT

HEy,

but in second case , i ahve to create 4 different charts . But i dont want to create 4 different charts.

Re: Prob regarding chart

jonathandienst — Tue, 17 Mar 2015 12:47:40 GMT

You create one chart, then clone it 3 times and change just the chart type on the general properties tab.

Re: Prob regarding chart

buzzy996 — Tue, 17 Mar 2015 13:05:44 GMT

no need to create 4 different charts,just clone(right click on ur chart object select clone and change the chart type from general tab) it and apply the condition on layout tab.