topic Re: Set analysis respond to filter as modifier in QlikView

Set analysis respond to filter as modifier

MindaugasBacius — Mon, 22 May 2017 06:33:52 GMT

Hello,

I have expression like:

Sum(

Region = {"USA", "Asia"}

Sales)

How do I make this expression to respond to the filter Region Asia?

Thank you!

ahaahaaha — Mon, 22 May 2017 06:53:49 GMT

Hi,

May be

Sum({<Region = {'Asia'}>} Sales)

avinashelite — Mon, 22 May 2017 06:59:01 GMT

What you mean by expression to respond ? if you want the expression to respond for filter you apply simply try like this

Sum(Sales)

if you want the expression to remain constant for the Asia then use Sum({<Region = {'Asia'}>} Sales)

tresB — Mon, 22 May 2017 07:01:30 GMT

May be this?

Sum(

{< Region *= {'Asia'}>+< Region = {'USA'}>}

Sales)

Kushal_Chawda — Mon, 22 May 2017 07:15:09 GMT

try this

Sum(

Region *= {"USA", "Asia"}

Sales)

MindaugasBacius — Mon, 22 May 2017 07:33:25 GMT

Thank you for your answers.

I have just decided to make a trigger for my issue.

tresB — Mon, 22 May 2017 07:36:47 GMT

None of our solutions work? Or we misread your requirement?

Kushal_Chawda — Mon, 22 May 2017 07:38:57 GMT

You should avoid triggers as far as possible. Solution suggested by me or Tresesco should work