Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Data from one table

Hi All,

I have created a table in qlikview using so many calculations.

Now i need to consume same data in another chart.

How do i use that ???

Please find the attachment for more information


Keerthi KS

12 Replies

Can you be more specific of what you dimensions and expressions that you would like to see in the bar chart?



Not applicable

if your issue is using the expressions you have already written but want them in a different chart type, you can copy the entire chart and then paste it, drag the new chart off of the old one and go to General and change the chart type and remove any expressions that do not apply.

Your other option is to create a new chart from scratch and copy/paste the expressions from the first chart into the new one

This is assuming I understand your question correctly


Also assuming I understand you correctly I'll expand on Adam's suggestion to 3 options :

  1. Duplicate your expressions in multiple Chart Objects
    • Con:  Multiple different yet identical expressions will need to kept in sync.  Mistakes could produce different values for things that should be identical

  2. Put your expressions into variables:
    • Pro: Each variables will be a single version of the truth

  3. Pre-calculate the expressions in the load script creating a Fact column for each one
    • Pro:  Front end expressions will be simple and the dashboard will probbaly have better performance

My preference would be Option 3, if not viable then Option 2 [or maybe a mix of 2 & 3]

I would avoid Option 1, otherwise one could well end with multiple versions of the truth in a single dashboard qvw.

Not applicable


I agree with you 100% - from my quick look at the application, it did appear that variables were used quite extensively.

If your expressions are in variables, then you will not have multiple versions because you would just need to change the variable if the calcuylation changes and then all of the expressions get updated and are the same

It is always best practices to precalculate as much as possible

Not applicable

I jsut revisted the applciation and although you have defined a lot of variables, I did not see them in the expressions.  I would make the expressions variables and then use the variables in multiple charts if you cannot precalcalcualte in the script

Not applicable

This actually dint work in my case. Since there are many dimensions.


How did the dimensions make it not work ?

Not applicable

can you please go into further detail in describing what it is you want to do?

Not applicable

In the table you can see the specification.

I want to create a chart based on only specification.

Lets say Specification Orange with Connect Incentive, Response Incentive and all the other incentives.

My chart dimension is only specification and all the expressions in the table.