Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I encounter problem to get the right answer and need help on followings :
1. To compare the result of a selected Class (eg E) with the average result of the Rest (A,B,C & D),
2. To express KPI-1 in %, KPI-2&3 in two decimals and KPI-4 to 6 in %.
Thank You
Tracy
for KPI1 just use different format string (e.g. '$#,##0.00':
hope this helps
regards
Marco
Hi,
one possible solution might be:
hope this helps
regards
Marco
Dear Marco
Appreciate your good advice. Kindly help to explain what is "e(Class)" ? and how to change KPI-1 to $41,105 or $0.
Thank you very much
Tracy
Date: Sun, 28 Sep 2014 09:44:15 -0400
From: qcwebmaster@qlikview.com
To: tracycrown@hotmail.com
Subject: Re: - Comparison
Qlik Community
Comparison
reply from Marco Wedel in New to QlikView - View the full discussion
Hi,
one possible solution might be:
http://community.qlik.com/servlet/JiveServlet/downloadImage/2-620628-67816/QlikCommunity_Thread_135287_Pic1.JPG.jpg
http://community.qlik.com/servlet/JiveServlet/downloadImage/2-620628-67817/QlikCommunity_Thread_135287_Pic2.JPG.jpg
hope this helps
regards
Marco
Reply to this message by replying to this email, or go to the message on Qlik Community
Start a new discussion in New to QlikView by email or at Qlik Community
Following Comparison in these streams:
Inbox
© 1993-2014 QlikTech International AB
Copyright & Trademarks | Privacy | Terms of Use | Software EULA
e(Class)
means excluded from current Class selection (meaning all Classes NOT being selected)
for KPI1 just use different format string (e.g. '$#,##0.00':
hope this helps
regards
Marco