Table with same article but different codes

[#1]

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

[Michael_Tarallo]

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

[#3]

Sorry,

I posted it in the wrong forum.

I'll post in the right one now..

thank you

Kind Regards

Miriana

[mrossoit]

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.

MR

[#5]

Regards

Miriana

[mrossoit]

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.

MR