Show Values based on Variable

[ivandrago]

Hi,

I have a straight table chart, I then have a variable where the user will enter an amount, this amount will change the straight table below where the value from the input variable is greater than or equal to the amount that is in the straight table chart.

How would I do this?

Thanks

[MK_QSL]

Let vAmount is the variable where user will enter value in input box

SUM({<Price = {'>=$(vAmount)'}>}Price)

[ivandrago]

Thanks for this but I want the rows to hide? They are still showing from the attached

[Anonymous]

Add similar set analysis to your other 2 expressions :

     SUM({<Val = {'>=$(vAmount)'}>}Qty)

     SUM({<Val = {'>=$(vAmount)'}>}Cost)

[ivandrago]

Hi,

How do I amend it so that the column Web Link will hide based on the Amount Value?

Thanks

[Anonymous]

Ivan

On the Expression tab:

• Tick Conditional
• Enter Expression, maybe something like :
  • vAmount > 70

Then it will only show that column if the Conditional Expression is met and hide it if it is not met.

[ivandrago]

Hi Bill,

I don't actually want the Column to Hide, the variable is not limiting the rows and it has something to do with the Web Link column?

Thanks

[Anonymous · Accepted solution]

Ivan

Ooops!!  Completely misunderstood you.

Try something like this for the Web Link expression :

only({<

  Val = {'>=$(vAmount)'} ,

  Area={"=len(trim(Area))>0"}

  >}

  'open'&'<URL>'&'http://www.qlik.com')