topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Wed, 15 Jul 2015 00:45:07 GMT

Hi,

I have a question. I have a data like this

Place Name Cost

A Aa 1000

B Bb 2000

- Cc 3000

I want to show sum(cost) and exclude the data that doesn't has place, I used Name as dimension in the straight chart. I've try to use this expression :

=Sum({<Place=-{''}>}Cost)

It works perfectly, but i have a list box that contain Place Dimension. When i choose one place, lets say A the total value is 3000 (A+B) i want to make the total only A (1000) and only A is choosed. anybody knows how ?

Really appreciate your help, thanks.

Re: Set Analysis Problem

rwunderlich — Wed, 15 Jul 2015 00:57:24 GMT

If the "-" represents a null, then this should work:

sum({<Place=P()>}Cost)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Set Analysis Problem

Wed, 15 Jul 2015 01:05:26 GMT

Hi Rob,

Thanks for your answer, it works perfectly, but it returns red underline (error) in the expression. Do you know how to solve the error ?

Thanks

Re: Set Analysis Problem

sunny_talwar — Wed, 15 Jul 2015 01:28:00 GMT

Its not an error, its just means that expression editor doesn't understand the syntax. If you still insist to have the red line removed, you can try this:

Sum({<Place = {'*?'}>}Cost)

Re: Set Analysis Problem

Wed, 15 Jul 2015 01:34:19 GMT

Hi,

Thanks Rob and Sunindia, you guys are good problem solver.

Thanks

Re: Set Analysis Problem

sunny_talwar — Wed, 15 Jul 2015 01:35:42 GMT

No problem

Glad we were able to help.

Best,

Sunny

Re: Set Analysis Problem

rwunderlich — Wed, 15 Jul 2015 01:56:21 GMT

Sunny, your solution will remove the syntax error, but I believe it creates the original problem. It will ignore any selections made in "Place".

This form will make the syntax checker happy and honor selections in Place.

=sum({<Place=P({$})>}Cost)

-Rob

Re: Set Analysis Problem

sunny_talwar — Wed, 15 Jul 2015 09:38:51 GMT

Thanks for catching that Rob‌, I need to spend a little more time reading the requirement before responding to them

Best,

Sunny