topic Re: Expresion chart in QlikView

Expresion chart

rodri_morales — Fri, 13 Sep 2013 16:16:47 GMT

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?

Re: Expresion chart

swuehl — Fri, 13 Sep 2013 17:30:42 GMT

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

Re: Expresion chart

rodri_morales — Fri, 13 Sep 2013 17:38:58 GMT

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.

Re: Expresion chart

tresB — Fri, 13 Sep 2013 18:10:19 GMT

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

Re: Expresion chart

Fri, 13 Sep 2013 19:24:31 GMT

You can create a button with action to select the field Escanje with the following action

Field select "Escanje"

= if (Escanje = 1,0,1).

Already in use table expressions

=sum({< Escanje= {0}>} Amount)

=sum({< Escanje= {1}>} Amount)

Re: Expresion chart

CELAMBARASAN — Fri, 13 Sep 2013 19:49:25 GMT

Hi,

Check with whats new in Qlikview 11.Click Here

Go to Reports tab and check the Dimensions and measures list box.

Re: Expresion chart

rodri_morales — Mon, 16 Sep 2013 12:39:46 GMT

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