Calculated Variable

Fri, 02 Sep 2016 08:39:58 GMT

Hi everyone,

I need a hint about a calculated measure on some specific variables.

As you can see in the picture, there is a pivot table based on some calculate variables ans a KPI field.

On the left, in the KPI, there is the total of $(operazioniValideTotal), defined as:

count({<[NomeEsitoOperazione]= {'Successo'}>} total(IDOPERAZIONE))

In the pivot table, the dimensions are "Campagna Master" and "Campagna Sponsor" and the hierarchy is Campagna Master>Campagna Sponsor.

The first measure (Eventi Elaborati con successo) is the $(operazioniValide), that is specific for the dimension Campagna Master (red circle) and the campagna Sponsor. The sum of Campagna Sponsor's values are the Campagna Master value.

The $(operazioniValide) is defined as:

count({<[NomeEsitoOperazione]= {'Successo'}>} IDOPERAZIONE)

The other Measure (% Carico Attuale) is based on the ratio between the $(operazioniValide) and $(operazioniValideTotal).

My request is that the measure (% Carico Attuale) will be based on the specific value of the "campagna Sponsor" measur over the value of their "Campagna Master" value.
For example: look at the green rectangle.

This value is based on:

3/39 = 0.076 (7.6%)

25/39 = 0.64 (64%)

I need that this value is :

3/28 = 0.107 (10,7%)

25/28 = 0.893 (89.3 %)

This value will appear only if I selected the "campagna Master" and so Qlik will calculate the $(operazioniValideTotal) based on that selection.

Re: Calculated Variable

sunny_talwar — Sat, 03 Sep 2016 18:16:26 GMT

Try this in the denominator

Count({<[NomeEsitoOperazione]= {'Successo'}>} TOTAL <[Campagna Master]> IDOPERAZIONE)

Re: Calculated Variable

Mon, 05 Sep 2016 07:22:26 GMT

Thanks! Right Answer

topic Calculated Variable in App Development

Calculated Variable

Re: Calculated Variable

Re: Calculated Variable