Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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