topic expressions in QlikView

expressions

Thu, 25 Dec 2014 16:18:32 GMT

how to create such a calculation to

in the column was calculated

sum ()

Enterprise 1 - 100 (minimum value of the Sample)

......

Enterprise 3 - 300

Re: expressions

Anonymous — Thu, 25 Dec 2014 18:18:49 GMT

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

Re: expressions

Thu, 25 Dec 2014 18:28:36 GMT

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

Re: expressions

Thu, 25 Dec 2014 18:35:36 GMT

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

Re: expressions

Thu, 25 Dec 2014 18:43:24 GMT

the meaning of this

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

Re: expressions

Thu, 25 Dec 2014 19:00:43 GMT

the meaning of this

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

Re: expressions

Anonymous — Thu, 25 Dec 2014 19:09:08 GMT

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

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

Re: expressions

Thu, 25 Dec 2014 19:16:52 GMT

Hi,

Can you attach the sample data.

so that we can help you in better way.

Sub2u

Re: expressions

Thu, 25 Dec 2014 19:24:26 GMT

should ideally be so

thank

Re: expressions

Thu, 25 Dec 2014 19:25:07 GMT

thank, this is something )

Re: expressions

Anonymous — Wed, 31 Dec 2014 15:28:17 GMT

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

You can find my solution in the green column.

Elena