Chart To Table

[smilingjohn]

HI ALl

I have attached a qlikview file , there is a chart called Revenue deep Dive For Services

if u can see there is a button being used when i click on it it will open the Table formate for all the values in the chart.

Can some one please explain me how to achieve this ?

I hope u will do the need full , I tried but iam not able to understand how to do this .

thanks

[vardhancse · Accepted solution]

in chart properties->General<tab>->Fast change Type(Allowed Types>->Select the straight table and chart.

Preferred Location: In Chart/In Caption

In Chart will give multiple option

In Caption: we can see >> button where on click the alternate chart/table will be displayed

[jonathandienst]

Fast change allows the user to select an alternative format. If it is button based, then it is probably a conditional show using 2 objects - the chart and the table, and the button toggles the display by setting a variable value used in the conditional show expressions.

[vardhancse]

Hi,

As Jonathan mentioned yes its possible to toggle the chart type using the button and a variable.

we need to create one variable(For rg vchart=1)

In chart->Properties->Layout<tab>->Condition->Give vchart=1

In Table->Properties->Layout<tab>->condition->Give vchart=1

For the button->Actions->Action Type(External)->Set Variable

if(vchart=1,1,0)

So that the one button can use to be toggle between chart and table

[Siva_Sankar]

[Siva_Sankar]

Clicking on the button activating a sheet and showing the table.

[Siva_Sankar]

Variable values are used in sheet properties to show or hide. see sheet properties below.