Solved: Smallest value per dimension-element - Qlik Community

Report Inappropriate Content · ‎2010-06-16

Hi,

I have the following problem:

Source-Table is

Seller | Product | Price

S1 | P1 | 3.09

S1 | P2 | 3.29

S1 | P3 | 6.09

S2 | P1 | 2.99

S2 | P2 | 3,49

S2 | P3 | 5.39

S3 | P1 | 3.19

S3 | P2 | 2.59

S3 | P3 | 6,49

Desired Table with best price per product

Seller | Product | Price

S2 | P1 | 2.99

S3 | P2 | 2.59

S2 | P3 | 5.39

How can I solve this? Maybe a question of designing the formula.

Thanks

Report Inappropriate Content · ‎2010-06-16

Hi,

Perhaps not the best of the expressions but would solve your problem

Add Product & Seller in dimensions and in the expression write

= if ( min(total < Product> Price) - Price < 0 , 0, Price)

Now supress Zero values in the presentaitons Tab and it works

Again not the ideal solution I guess

Report Inappropriate Content · ‎2010-06-16

Hi,

Perhaps not the best of the expressions but would solve your problem

Add Product & Seller in dimensions and in the expression write

= if ( min(total < Product> Price) - Price < 0 , 0, Price)

Now supress Zero values in the presentaitons Tab and it works

Again not the ideal solution I guess

Report Inappropriate Content · ‎2010-06-16

It works !

Thank you Umang

Smallest value per dimension-element