topic Re: Table with same article but different codes in QlikView

Table with same article but different codes

Thu, 09 Apr 2015 16:11:46 GMT

Hi everyone,

This is my table:

I want to underline or color the record with the same last 7 characters (like those in green and blue) in one colour.

For calculating the last 7 I do right(code,7).

For colour now i do if(right(code,7)=code,blue(170),(if(right(code,7)<>code,Green(170))))

Thanks to everyone can help me.

Kind regards

Miriana

Re: Table with same article but different codes

Michael_Tarallo — Thu, 09 Apr 2015 19:33:39 GMT

Hi Miriana,

Thanks for your post. Are you using Qlik Sense or QlikView? By the looks of the pic, it looks like QlikView.

If QlikView I can get your assistance in the QlikView Forums.

Regards,

Mike T

Qlik

Re: Table with same article but different codes

Thu, 09 Apr 2015 19:51:15 GMT

Sorry,

I posted it in the wrong forum.

I'll post in the right one now..

thank you

Kind Regards

Miriana

Re: Table with same article but different codes

mrossoit — Fri, 10 Apr 2015 08:33:59 GMT

Hi Miriana,

a condition like if(right(code,7)=code.. will return true only if code's length is 7.

If last 7 field is calculated in your graphic table (not in the script) and is always in the same record of the code from which it's derived, the test will always return true and this has no sense.

Last7 has to be a field independent by code and a condition like:

if(right(code,7)=last7, blue(170), Green(170))

will work if used in all background expressions of your table's columns.

Upload a sample qvw with more than 2 records loaded, please.

Re: Table with same article but different codes

Mon, 13 Apr 2015 07:34:21 GMT

Regards

Miriana

Re: Table with same article but different codes

mrossoit — Mon, 13 Apr 2015 08:09:46 GMT

I suggest you to calculate last7 dimension in the script and replace calculated dimension last 7 in your straight table with that new field.

Then add an expression labeled aux defined as

if(last7<>Above(TOTAL last7), if(above(TOTAL aux)=0, 1, 0), above(TOTAL aux))

and use this condition in background expression of last7 dimension:

if([aux] = 1, blue(170), green(170))

Finally, if you don't want to use pivot layout, you could hide aux expression checking hide column in graph tab of straight table properties.

Download my sample from here:

Come alternare i colori in una tabella pivot

or here:

How to alternate dimension's colour on pivot tables

If your qvw still wont work, upload it so I'll give it a look.

Good luck.