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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expressions

hi

how to create such a calculation to

in the column was calculated

sum ()

Enterprise 1 - 100 (minimum value of the Sample)

......

Enterprise 3 - 300

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Please, see the attachment and let us know if it is correct!

You can find my solution in the green column.

KR

Elena

View solution in original post

10 Replies
Anonymous
Not applicable
Author

Please, can you explain your question in a more detailed way?

Not applicable
Author

try, in summary

we need to get

FOR Enterprise 1 = sum (Price for Sample 1), ie. To the field Sample: sample 1 <sample 2 and sample 3 - to present it as a serial number. (Min String) and  = 100

For Enterprise 2 = sum (Price for Sample 4), ie. To the field Sample: Sample 4 <5  sample (Min String)  and  = 400

Not applicable
Author

Hi,

Use Class Function.....

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'


class( var,10 )

here 10 is interval.

if var =23 , then if your data of field start from 10 then after interval of 10 , 23 lie between 20 to 30.

so
var=23 return 20<=x<30

Not applicable
Author

the meaning of this

Sum({<Sample = MinString(Samle)>} Price)

Not applicable
Author

the meaning of this

Sum({<Sample = MinString(Samle)>} Price)

Anonymous
Not applicable
Author

This should be the correct formula, but it seems it doesn't work

MinString({<Sample={"$(=minstring(Sample))"}>} Price)

Not applicable
Author

Hi,

Can you attach the sample data.

so that we can help you in better way.

Sub2u

Not applicable
Author

should ideally be so

7440c-clip-4kb.png

thank

Not applicable
Author

thank, this is something )