Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want to exclude one value in the field i'm using as dimension could you please help me about that?
i want to display Motor without '28 inch' for example.
Hi abdallah,
one way is to replace the list box dimension with an expression e.g.
if(Motor <> '28 Inch', Motor)
Andy
Hi abdallah,
one way is to replace the list box dimension with an expression e.g.
if(Motor <> '28 Inch', Motor)
Andy
Hi,
You can achieve this using Calculation Dimension like below
If(Motor <> '28 Inch', Motor)
If you are doing this in chart you can exclude this in Set analysis expression
=Sum({<Motor -= {'28 Inch'}>} Sales)
Hope this helps you.
Regards,
Jagan.
If you want to avoid both "28 Inch"'s you could transform the value within the conditional check.
if(lower(Motor) <> '28 inch', Motor)
in this case don't forget to write 28 inch in lower case
Patrick
Maybe it's better to add some applymap() translation to your script so that different spellings all map to the same Dimension value?
Or a simple ...CAPITALIZE(Motor) AS Motor, ... in your script may already do wonders...
try this, use expression instituted of field in ur list box.