Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rodri_morales
Contributor II

Expresion chart

Hi everyone, I have a problem, I want to make a chart with dimension=User and a calculated expresion, but I want to make a table with 2 options and when I click on one the chart show the results. I want this expresions in the same chart, but depends on where I click, the chart show "Pagos" or "Canje"

The expresions are:

=sum(if(EsCanje=0, amount)

=sum(if(EsCanje=1, amount)

The table must show "Pagos" and "Canje" (they are determined by the attribute "EsCanje", if EsCanje=0 --> Pago, if EsCanje=1 --> Canje).

How I have to do?

1 Solution

Accepted Solutions
rodri_morales
Contributor II

Re: Expresion chart

I can do it. I maje a table with the value 'Tipo de Pago' like this:

if(EsCanje=0, 'Pagos', if(EsCanje=1, 'Canje')) as 'Tipos de Pago'

Then I use the expresion sum(amount) and when I click in a value of the table, the chart change

6 Replies
MVP
MVP

Re: Expresion chart

Not sure if I've  understood your requirement correctly.

You can create a variable and a button with an action to switch between two values.

Then use a chart with your two expressions, and set conditionals based on the variable value for both expressions.

Hope this helps,

Stefan

rodri_morales
Contributor II

Re: Expresion chart

I want to make a table with two expresions: "Pagos" (if EsCanje=0) and "Canje" (if EsCanje=1), and when I click on one of this values, the chart change the expresion, but always with the same Dimension (Users).

The chart has one dimension and I want to select from a table of 2 values, and when I click the chart must show me the results for that value.

MVP
MVP

Re: Expresion chart

May be, you can try with ValueList()/ValueLoop().

This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.