topic Re: Comparison in QlikView

Comparison

tracycrown — Sun, 28 Sep 2014 08:49:39 GMT

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

Re: Comparison

MarcoWedel — Sun, 28 Sep 2014 13:43:31 GMT

Hi,

one possible solution might be:

hope this helps

regards

Marco

Re: Comparison

tracycrown — Sun, 28 Sep 2014 15:51:38 GMT

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

Re: Comparison

MarcoWedel — Sun, 28 Sep 2014 15:53:44 GMT

e(Class)

means excluded from current Class selection (meaning all Classes NOT being selected)

Re: Re: Comparison

MarcoWedel — Sun, 28 Sep 2014 15:58:25 GMT

for KPI1 just use different format string (e.g. '$#,##0.00':

hope this helps

regards

Marco