Discussion Board for collaboration on QlikView Scripting.
How can I convert the graphic attached to the image?
Go to Solution.
Either add all field names that are part of the dimension group to the TOTAL qualifier field list or use GetCurrentField():
Count(TOTAL<Combustible, AnotherFieldName1, AnotherFieldName2> Poliza)
Count(TOTAL<[$(=GetCurrentField( "Group Cyclico"))]> Poliza)
and format number as percentage on number tab
Excellent! And could you rewrite the sentence if the dimension is a cyclic group?
It works! thank you very much. Why is the formula Underline in red?
That's because the syntax checker can't really handle the dollar sign expansions $(=...)
It's a limitation of the checker, so you need to test the result yourself.
Every day you learn something!
thank you very much