Help needed: SET Analysis to eliminate a record in a sales column

[#1]

Hi All,

I am new to Qlikview, I have an issue like, I used a set funtion to eliminate one record in a total count. but getting a script line error.

The data used is from EXCEL sheet and data about indian states. in that I need to eliminate the sales report of Maharashtra and get the total

function I used is set sum( {MAHARASHTRA-$} Sales). Please help me to get out of this. Please find the attachment.

Thanks in advance.

Regards,

Sarath

[MayilVahanan]

Hi

Try like this

=Sum({<State -={'MAHARASHTRA'}>}Sales)

Hope it helps

[#3]

Thanks for your help Mayil. I tried it but I see no changes to the result. The issue is I have a table which contains details of states. My requirement is to sum up the sales of all states except MAHARASHTRA?

I just used the statement you refered, but no change in the result. How to eliminate a particular column using set analysis? One more clarification, should we use the SET statement only before Load and From? the input is an EXCEL sheet.

[sivarajs]

You cant use set in script

But you can try sum(if(state<>'MAHARASTRA',sales) followed by group by expression

Like

load sum(if(state<>'MAHARASTRA',sales) as sales

from a.qvd group by state;