Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Making a selection (filter) of fields on just one expresstion in a diagram

Hi!

Yesterday I got some great help here so I try again.

I have a diagram (pivot) where I what one of the extression to select several values.

If I only whant onwe valu then this works:

=((sum({<[PD] = {'$(vCurrentPD)'}>} Belopp)))

But I whant a range of "PD" from 'startPD' to 'vCurrentPD'

 

=((sum({<[PD] = "From 'startPD' to vCurrentPD'     Belopp)))

Any ideas?

Thank you

Jonny

 

1 Solution

Accepted Solutions
Not applicable

Re: Making a selection (filter) of fields on just one expresstionin a diagram

Hi Jonny,

something like the below should work

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

hope that helps

Joe

3 Replies
Not applicable

Re: Making a selection (filter) of fields on just one expresstionin a diagram

Hi Jonny,

something like the below should work

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

hope that helps

Joe

Not applicable

Re: Making a selection (filter) of fields on just one expresstion in a diagram

Works perfektly, Thanks

Not applicable

Re: Making a selection (filter) of fields on just one expresstion in a diagram

no worries, glad to be of help, maybe check out this thread for a bit more info on set analysis

Set Analysis: syntaxes, examples

Joe

Community Browser