topic Re: exclude records in QlikView

exclude records

Fri, 21 Sep 2012 18:26:01 GMT

I know that you can exclude record in a script but I'm using the same script for mulitple things.

On this one sheet I need to exclude all [suspend code balance] = ['N'} from the selection for this sheet.

How can I do that? I don't want the stock numbers to show up in the chart unless some of the records for that item are "N"

MayilVahanan — Fri, 21 Sep 2012 18:36:35 GMT

Try alternate state for that particular field

Hope that helps

Sat, 22 Sep 2012 08:04:06 GMT

Hai

try with alternate states for solving u r problem.In alternate states u can use it seperately for different sheets on selections.

it may helps u

whiteline — Sat, 22 Sep 2012 08:11:16 GMT

Hi.

You can use set analysis to modify selections for a particular expression and exclude some values, for example:

Sum({<[suspend code balance] -= {"N"}>} Value)

jagan — Sat, 22 Sep 2012 09:38:21 GMT

Hi,

You can exclude the values of dimension by using "-=" operator. For example

=Count({<[suspend code balance] -= {'N'}>} DimensionName)

Hope this helps you.

Regards,

Jagan.