Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hi Jonny,

something like the below should work

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

hope that helps

Joe

View solution in original post

3 Replies
Not applicable
Author

Hi Jonny,

something like the below should work

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

hope that helps

Joe

Not applicable
Author

Works perfektly, Thanks

Not applicable
Author

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