Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Replacing numbers with images in pivot table, but not totals

I have a pivot tables with numbers that represent percentages (0,25,50,75,100). My totals are average of the percentages which might be a number with decimals. I use Show Partial sums option on the Presentation Tab

and my expression is

=(sum(A])/count())/100

I want to replace cell's values with "Consumer Report" like circles. I do it with the if statement on the expression like:

=if (Match(,'100'),'qmem://Image Name/100',

if (Match(,'75'),'qmem://Image Name/75',

if (Match(,'50'),'qmem://Image Name/50',

if (Match(,'25'),'qmem://Image Name/25',

if (Match(,'0'),'qmem://Image Name/0')))))

, but as soon as I do it the totals are also got replaced with images. How can I leave totals as  numbers?

Any Ideas? Thank you

5 Replies
srikanthsri1
Valued Contributor

Re: Replacing numbers with images in pivot table, but not totals

try using column function like

if ( column(1)<20 ,'Image1,

if(column(1)>40,'Image2','Image3')

Hope it helps

Sri1

Not applicable

Re: Replacing numbers with images in pivot table, but not totals

were would I use this code?

srikanthsri1
Valued Contributor

Re: Replacing numbers with images in pivot table, but not totals

add this as another expression

antoniotiman
Honored Contributor III

Re: Replacing numbers with images in pivot table, but not totals

You try with function Dimensionality() (see Guide).

Row TOTAL is Dimensionality() 0, etc.

if(Dimensionality() > 0,Image1,sum(.......))

Regards

Not applicable

Re: Replacing numbers with images in pivot table, but not totals

It does not work, Another expression ads another column and also changes total to images

Community Browser