topic Re: Show Values based on Variable in QlikView

Show Values based on Variable

ivandrago — Fri, 22 Aug 2014 15:54:44 GMT

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

Re: Show Values based on Variable

MK_QSL — Fri, 22 Aug 2014 15:58:03 GMT

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

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

Re: Re: Show Values based on Variable

ivandrago — Fri, 22 Aug 2014 16:27:41 GMT

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

Re: Show Values based on Variable

Anonymous — Fri, 22 Aug 2014 16:32:18 GMT

Add similar set analysis to your other 2 expressions :

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

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

Re: Re: Show Values based on Variable

ivandrago — Tue, 26 Aug 2014 11:24:19 GMT

Hi,

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

Thanks

Re: Show Values based on Variable

Anonymous — Tue, 26 Aug 2014 11:42:40 GMT

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.

Re: Show Values based on Variable

ivandrago — Tue, 26 Aug 2014 12:13:34 GMT

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

Re: Re: Show Values based on Variable

Anonymous — Tue, 26 Aug 2014 12:34:58 GMT

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')