topic Re: Separate values in QlikView

Separate values

mromrod22 — Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

I have a problem with a chart when I must show values separated in reviews.

Depending of Cheks of "Selector Anual", must show a specific values, but now show accumulated values.

Expected output for each Review (revision):

For example, if check Rev0 and Rev1, must show the next values:

Enero: 0.17

Febrero: 0.84

Marzo: 1.28

Abril: 2.42

Mayo: 2.53

Junio: 1.68

Julio: 1.51

Agosto: 1.70

Septiembre: 2.44

Octubre: 2.18

Noviembre: 1.90

Diciembre: 0.42

But the current output is the next:

In Mar, show 3.12 (sum of Rev0 and Rev1 for Mar)

Now, I need show without accumulation.

Attach a qlik with the problem.

Help me buddy's.

Thanks.

Re: Separate values

karthiksrqv — Thu, 30 Mar 2017 08:58:36 GMT

Hi,

If there is any field that allows you to filter only for 1.28 march value, you should put that in the set expression. This should get you the result as expected.

Re: Separate values

Peter_Cammaert — Thu, 30 Mar 2017 12:05:26 GMT

The attachment shows a technique to accomplish this. It works by first converting the Rev indicators into values with a numerical component, and by using these to order the values sequentially and picking the correct one using FirstSortedValue().

A solution is maybe impossible to create if we don't know how the values for Rev/Month combination are calculated. Therefore you may want to replace the expression in the Result table with something like

=FirstSortedValue(aggr(expr,...), -Rev)

where expr should be replaced with the original aggregation that calculates these values.

Best,

Peter