Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Chart To Table

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

1 Solution

Accepted Solutions
vardhancse
Specialist III
Specialist III

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

View solution in original post

6 Replies
vardhancse
Specialist III
Specialist III

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
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vardhancse
Specialist III
Specialist III

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
Master II
Master II

untitled.bmp

Siva_Sankar
Master II
Master II

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

activating sheet.bmp

Siva_Sankar
Master II
Master II

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