topic Chart To Table in QlikView

Chart To Table

smilingjohn — Fri, 29 May 2015 05:22:50 GMT

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

Re: Chart To Table

vardhancse — Fri, 29 May 2015 05:24:58 GMT

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

Re: Chart To Table

jonathandienst — Fri, 29 May 2015 06:31:07 GMT

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.

Re: Chart To Table

vardhancse — Fri, 29 May 2015 06:36:24 GMT

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

Re: Chart To Table

Siva_Sankar — Fri, 29 May 2015 06:43:33 GMT

Re: Chart To Table

Siva_Sankar — Fri, 29 May 2015 06:46:21 GMT

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

Re: Chart To Table

Siva_Sankar — Fri, 29 May 2015 06:48:39 GMT

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