Need Selected data

[soniasweety]

Hi all,

Frank Hartmann

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]

Hi,

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

[Frank_Hartmann]

which dimensions are you using?

[sebastianlettner]

Hallo,

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

Selected Period:

Sum(totamt)

or

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)

or

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

and

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

Regards

Sebastian Lettner