Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Make an expression for last years period


Since this forum is so helpfull I try agin for som help.

I have two expression that is working  well:

Sum({$< PD = {'>=$(startPD) <=$(vCurrentPD)'}>} Belopp )

Sum({<[År]={$(=max([År])-1)} >} Belopp),
Sum({<[År]={$(=År-1)}>} Belopp))

I alos have this with a selection in it

if (GetSelectedCount([År])<>1,
-Sum({<[Rrnummer] = {16}, [År]={$(=max([RäkÅr])-1)} >} Belopp)/1000,
-Sum({<[Rrnummer] = {16}, [År]={$(=RäkÅr-1)}>} Belopp)/1000)

The first one gives me the the sum until august (PD=8)

This works no matter what selection I do in year (=År)

The second gives me the sum for last year but of cours all PD in last year.

That want to do is to combin this so I will show last years belopp until current PD

Any ideas of How to combine these?



Community Browser