topic Subtraction in SET in QlikView

Subtraction in SET

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm trying to do a minus (subtraction) using SET but it only returns the first row of data and doesn't return the second row of data.

Please provide assistance.

Thanks,

alexdataiq — Thu, 21 Apr 2016 16:07:32 GMT

Maybe try this:

=money(

sum({<Department={'Technology'}, [Fund Manager]={'Goldman Sachs', 'Smith Barney'}>} Sales)

sum({<Department={'Finance', 'Marketing', 'Corp Bond Sales'}, [Fund Manager]={'Goldman Sachs', 'Smith Barney'}>} Sales)

)

Cheers

sunny_talwar — Thu, 21 Apr 2016 16:10:08 GMT

Its difficult to know what you are trying to do just by looking at the expression. Do you have a sample that you can share with us?

Thu, 21 Apr 2016 16:17:49 GMT

Thanks Guys for all your help!!!!!

alexdataiq — Thu, 21 Apr 2016 16:24:58 GMT

Glad to help!