topic Re: Need Selected data in QlikView

Need Selected data

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

Hi all,

I want to display the data of selected period. and prior period of count totalamount

Image I need as output. and sample is attached.

how can I achieve this?

= count(totamt)

Anonymous — Tue, 26 Sep 2017 09:53:41 GMT

Hi,

Perhaps you can look into alternate states:Alternate States ‒ QlikView

Frank_Hartmann — Tue, 26 Sep 2017 10:22:59 GMT

which dimensions are you using?

sebastianlettner — Tue, 26 Sep 2017 15:03:37 GMT

Hallo,

if you hane a consecutively numbered periodID you can use Set-Analysis like this

Selected Period:

Sum(totamt)

Sum({<periodID={"$(=Max(periodID))"}>} totamt)

if you can select more than 1 period and

Sum({<periodID={"$(=Max(periodID) - 1)"}>} totamt)

for the previous period

if you want to select 2 different periods use an alternative state and use it in the Set.

e.g.

You have 2 Sets

Set1 and Set2

Sum({ [Set1] }totamt)

Sum({ [Set1] <periodID={"$(=Max(periodID))"}>} totamt)

and

Sum({ [Set2] <periodID={"$(=Max(periodID))"}>} totamt)

Regards

Sebastian Lettner