Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Need Selected data

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)

3 Replies
thabang_petje
Partner
Partner

Hi,

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

Frank_Hartmann
Master II
Master II

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