topic Re: Conditional Show in Expression based on variable value in QlikView

Conditional Show in Expression based on variable value

Wed, 12 Aug 2015 02:33:53 GMT

I have a list of customers and their total sales value in a table. I also have a slider/input box that allows me to adjust a variable "vSalesValue"

In my table, I would like to be able to see only sales value that falls above the value define in the variable.

I've tried the following expression but it doesn't seem to work:

sum({<sum(Sales_Value) = {'>=$(vSalesValue)'}>} Sales_Value)

Any advice will be appreciated!

settu_periasamy — Wed, 12 Aug 2015 02:58:25 GMT

Hi,

May be try this,

sum({<Sales_Value = {'>=$(=vSalesValue)'}>} Sales_Value)

if(Sum(Sales_Value)>=$(vSalesValue),Sum(Sales_Value))

sunny_talwar — Wed, 12 Aug 2015 04:19:07 GMT

Try this:

=Sum({<Sales_Value = {"=Sum(Sales_Value) >= $(vSalesValue)"}>} Sales_Value)