topic Re: Help With Table in QlikView

Help With Table

Thu, 11 Jun 2015 12:12:28 GMT

Hi Guys

I was hoping someone could help. I have a chart as shown in the pic. I was hoping there was a way to add a third emoticon if there is no greater or smaller than figure returned. Please let me know if there is more detail needed.

Regards

Re: Help With Table

sunny_talwar — Thu, 11 Jun 2015 12:24:01 GMT

Are you trying to get a new emoticon for when 2012 and 2013 are both 0??

Re: Help With Table

alexandros17 — Thu, 11 Jun 2015 12:25:00 GMT

Could you share your qvw and explain the question with more details?

Re: Help With Table

sorrakis01 — Thu, 11 Jun 2015 12:27:45 GMT

Hi ashley,

Are you using Bundle method for the icons?

You can create 3 icons.

And after in expresion use the conditional expresion (If 2014>2013, green, If 2014<2013, red, yellow)

Regards

Re: Help With Table

Peter_Cammaert — Thu, 11 Jun 2015 12:31:15 GMT

You mean if LY and CY have equal values (or both are zero)? Normally you check for something like A<B->Icon1 else Icon2. Change this into something like:

=IF (ColumnY2 < ColumnY1, 'PathToIconLT', IF (Column2 > Column1, 'PathToIconGT', 'PathToIconEQ')).

Peter

Re: Help With Table

Thu, 11 Jun 2015 12:31:16 GMT

Yes i would like it if the value is 0 then a yellow emoticon. My expression is the following.

=if(sum({<Year={'2012'}>} [Mass Out]*IsProduction) >= sum({<Year={'2013'}>} [Mass Out]*IsProduction),

'qmem://<bundled>/BuiltIn/smiley3_r.png','qmem://<bundled>/BuiltIn/smiley1_g.png')

Regards

Re: Help With Table

Peter_Cammaert — Thu, 11 Jun 2015 12:33:49 GMT

=if(sum({<Year={'2012'}>} [Mass Out]*IsProduction) > sum({<Year={'2013'}>} [Mass Out]*IsProduction),

'qmem://<bundled>/BuiltIn/smiley3_r.png', if (sum({<Year={'2012'}>} [Mass Out]*IsProduction) < sum({<Year={'2013'}>} [Mass Out]*IsProduction),'qmem://<bundled>/BuiltIn/smiley1_g.png', 'qmem://<bundled>/BuiltIn/smiley1_y.png'))

Re: Help With Table

sunny_talwar — Thu, 11 Jun 2015 12:34:18 GMT

Try this:

=If(Sum({<Year={'2012'}>} [Mass Out]*IsProduction) > Sum({<Year={'2013'}>} [Mass Out]*IsProduction),

'qmem://<bundled>/BuiltIn/smiley3_r.png',

If(Sum({<Year={'2012'}>} [Mass Out]*IsProduction) < Sum({<Year={'2013'}>} [MassOut]*IsProduction), 'qmem://<bundled>/BuiltIn/smiley1_g.png', 'anotherImage'))

Re: Help With Table

Peter_Cammaert — Thu, 11 Jun 2015 12:34:45 GMT

Two nested IFs handle three cases: <, =, >

Peter

Re: Help With Table

Thu, 11 Jun 2015 12:35:27 GMT

That is perfect and works 100%. Thank you so so much for the help all.

Re: Help With Table

Peter_Cammaert — Thu, 11 Jun 2015 12:56:58 GMT

If you got a solution that satisfies your requirements, please close the discussion by marking an answer as correct. Thank you.

Peter

Re: Help With Table

awhitfield — Thu, 11 Jun 2015 15:05:57 GMT

Hi Ashley,

Can you please mark one of the replies as CORRECT, then it saves COMMUNITY MEMBERS from looking at answered calls?

Andy

Re: Help With Table

Fri, 12 Jun 2015 04:55:16 GMT

Hey Hey

New to the site and the only option i see is the actions tab to mark the answer as helpful. Where would the option to mark it correct be ?

Ash

Re: Help With Table

pratap6699 — Fri, 12 Jun 2015 06:46:37 GMT

If( 2014>2013, green, If (2014<2013, red, yellow)

Re: Help With Table

awhitfield — Fri, 12 Jun 2015 08:59:51 GMT

NO Problem. you should get the option, but you need to open the original thread