Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

cattaneoc
New Contributor

Relative graph

Hello,

How can I convert the graphic attached to the image?

Thank you!

Imagen2.jpg

1 Solution

Accepted Solutions
MVP
MVP

Re: Relative graph

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)


Or

Count(TOTAL<[$(=GetCurrentField( "Group Cyclico"))]> Poliza)

6 Replies
MVP
MVP

Re: Relative graph

As expression

Count(Poliza)

/

Count(TOTAL<Combustible> Poliza)

and format number as percentage on number tab

cattaneoc
New Contributor

Re: Relative graph

Excellent! And could you rewrite the sentence if the dimension is a cyclic group?

Grupo ciclico.jpg

MVP
MVP

Re: Relative graph

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)


Or

Count(TOTAL<[$(=GetCurrentField( "Group Cyclico"))]> Poliza)

cattaneoc
New Contributor

Re: Relative graph

It works! thank you very much. Why is the formula Underline in red?Subrayado en rojo.jpg

MVP
MVP

Re: Relative graph

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.

cattaneoc
New Contributor

Re: Relative graph

Every day you learn something!

thank you very much