Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sunilkumarqv
Specialist II
Specialist II

Get Min value of Expression

Hi ,

I need to get min value in expression into other

Example

Data,value

A,23

B,35

C,55

D,44

E,33

If Data was dimension then expression was sum(value) then in one more expression need get min value like below

Data,value,Min value

A,23, 23

B,35,-

C,55,-

D,44,-

E,33,-

11 Replies
sunilkumarqv
Specialist II
Specialist II
Author

what about in case of distinct values

Data,value

A,23

B,23

C,55

D,44

E,33

anbu1984
Master III
Master III

If(value = Min(TOTAL value),value)

146492.png