Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ruediger_schmidt
Contributor
Contributor

Trellis container (release november 2019 patch4) $(vDimSet) behave not as I expect it

Dear all,

my Trellis container contains a KPI-visualization as master visualization.
The KPI is

=Sum({$< [%PK_ORDER]= {$(vDimValue)}, RESULT-={0}, RULE_NAME={'FIT NOTES'}>} FREQUENCY)

The dimension of the Trellis container is %PK_ORDER
In the trellis container $(vDimValue) is transformed into ‘1’ (1 is a value of the dimension %PK_ORDER) as expected and the visualization works fine.

BUT!

As I change the KPI to

=Sum({< $(vDimSet),RESULT-={0}, RULE_NAME={'FIT NOTES'}>} FREQUENCY)


$(vDimSet) in trellis container turns into ,[=[%PK_ORDER]]={‘1’} which is not the expected result.
I would have expected [%PK_ORDER]={‘1’} and of cause the trellis container doesn’t show a mean full result.

What did I misunderstood? Syntax error?

Best regards
Ruediger

Labels (4)
1 Reply
Joost_d
Partner - Contributor
Partner - Contributor

Hi Ruediger,

A bit late though, but I had similar problems. According to what I see is that  $(vDimSet) always has a preceding comma, therefore place it at the end of your set analysis statement. 

I do agree that this is somewhat strange (not sure of a syntax error). I cannot think of any good reason to force one into a prescribed order in the set. If someone does, please enlighten me 😉 

Regards,

Joost