Hi Qlik Experts... Max and Min values from input box to display in Straight table.

[vangurideepu]

Hi Guys...! I have a question please clarify me.....

i want display possible max and min values in straight table but those min and max takes from input box.

Example: I have enter vMin=15000 in input box so its display the all below 15000 values like 15000,14000,13000... etc.

same as i have enter vMax=50000 in input box so its display the all above 50000,60000,70000 ... etc

Thanks in advance

Regards

Pradeep

[sunny_talwar]

Not sure I completely understand your requirement, would you be able to share your sample qvw with the expected output you would want to see in terms of numbers

[ramasaisaksoft]

Hi Pradeep,

we are unable to understand your requirement clearly

if you gave vmin & vMax values to which product it will consider first time? and after how it will judge for second product?

please explain your requirement  with sample data and expected output so that we will help to you.

[el_aprendiz111]

Hi,

Expressions

if(Value>=$(vMax),sum(value)) // max

if(Value<=$(vMin),sum(value)) // min

[Anonymous]

Hi Pradeep,

You can, try this:

For Min Value: Min({<Value={'<=$(vMin)'}>}Value)

For Max Value: Max({<Value={'>=$(vMax)'}>}Value)

Regards!

[adamdavi3s]

Yep and I think you just then need to add these together to put the results in the column as I think is the requirement

='Min: '&Min({<Value={'<=$(vMin)'}>}Value)&' Max: '& Max({<Value={'>=$(vMax)'}>}Value)

[vangurideepu]

Hi Sunny Bhai,

Thanks You for Quick reply....

Please Find the Attached Qvw file.

Regards

Pradeep

[Anonymous]

Hi Pradeep,

Use this expression:

=Sum({<Product_Name={"=SUM(Actual_MRP)<=$(vMin)"}>}Actual_MRP)

+Sum({<Product_Name={"=SUM(Actual_MRP)>=$(vMax)"}>}Actual_MRP)

Output: On green >vMax, on red <vMin

regards!!