topic Excluding a selection in QlikView

Excluding a selection

Tue, 27 Jul 2010 00:36:50 GMT

Hi all,

I have a simple chart showing values using the expression:
=Round(sum(Value)/1000, 0.1)

The user makes selections from two dimensions: Product and Account.

When the user selects a products, the chart will show total value for that product.

My requirement is as follows: when the user makes a selection from Accounts, the chart will just exclude that selected account from the calucation.

I tried to use Set Analysis like {1-$} but that would affect both the Product and Accounts.

I tried to use something like follows:

=Round(sum( {$<[Account_Name]=>} Value)/1000, 0.1) - Round(sum( {$<[Account_Name]=[Account_Name]>} Value)/1000, 0.1)

but that doesn't work if no account is selected. It will display zero.

Thanks in advance.

Excluding a selection

Tue, 27 Jul 2010 07:52:38 GMT

Hi,

Plz share sample database.

Excluding a selection

suniljain — Tue, 27 Jul 2010 08:11:26 GMT

Pls use Set analysis it will help you .you can get more help about set analysis from qlikview help.

Excluding a selection

Tue, 27 Jul 2010 08:12:14 GMT

I am attaching a sample file.

What I need is: if I select an account, let's say "A5", and a product "P2", I want the calculation in the chart to be summition of Value for ALL accounts except "A5" and summition of product "P2" only.

Thanks in advance.

Excluding a selection

Tue, 27 Jul 2010 08:16:46 GMT

Hi,

You will have to change the Set Expression. You can use the following expression

=if(getselectedcount([Account_Name])>0,

Round(sum( {$<[Account_Name]=>} Value)/1000, 0.1) - Round(sum( {$<[Account_Name]=[Account_Name]>} Value)/1000, 0.1),

Round(sum( {$<[Account_Name]=>} Value)/1000, 0.1) )

Excluding a selection

suniljain — Tue, 27 Jul 2010 08:24:48 GMT

Pls check