Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kristeljoymalapitan
Contributor

how to get the quotient of a measure and place in a gauge chart?

Hi,

I created measures column and I need to get the quotient to place in guage chart. Please see attached sample screenshot ,

If you divide the total  amount of coverage Amount / total amount of Actual past due  (634,797,174/3,230,335,814) you will get 19.65% however  10.29% was displayed,  I'm using MIN total function.

 

Please help me on this.

 

Thanks

ratio_comp.JPG

Labels (2)
2 Replies
kristeljoymalapitan
Contributor

Re: how to get the quotient of a measure and place in a gauge chart?

Anyone to address my concern please?

Support
Support

Re: how to get the quotient of a measure and place in a gauge chart?

You will likely need to attach the QVW or a sample QVW that shows the issue, so folks can see the data model as well as the expressions etc...

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.