topic Re: Price comparison in QlikView

Price comparison

Mon, 26 Jan 2026 18:19:17 GMT

Hi everyone,

I'd lite to create a tab such as the attached one , the purpose is to compare prices differences between each 'depot' for each reference. If there's any difference i'd like to have a color marker somewhere in the tab.

Thing is, I don't know how the expression will look like.

So as dimension : Reference, Dépot

As expression : Prices.

If you got any idea, i'd be glad to discuss about it

Wish you all the best Christmas parties,

Southinho

Re: Price comparison

Fri, 19 Dec 2014 11:49:41 GMT

Load * inline [Reference, Depot, Value
1,111,1000
2,111,800
1,112, 1000
2, 112,800
3, 113, 400
3, 112, 300];

Demension: Reference, Depot

Expression: sum(Value)

Background colour (can be seen by pressing the + button beside the expression): if(sum(Value) <> sum( distinct total <Reference> Value), lightred())

Re: Price comparison

alkesh_sharma — Fri, 19 Dec 2014 11:51:56 GMT

You can use colour mix wizard.

Re: Price comparison

Anonymous — Fri, 19 Dec 2014 12:29:25 GMT

hi,

you can use below expression in background color:

if(sum(Value) <> sum( distinct total <Reference> Value), lightred(),lightgreen())

Regards

Neetha