topic Re: Excluding specific Dimension in QlikView

Excluding specific Dimension

hschultz — Thu, 13 Dec 2012 08:01:47 GMT

Hi all

I have a scenario where we need to have selections, but the chart breaks if a speciffic selection is active.

There is an example attached:

We need to be able to select on the available boxes for Customer & Month, but then, because there is no link to the employee, selecting it does not display our budget anymore.

I know you can use set analysis for excluding all selections, but we do want to be able to pick Month & Customer

So the question is if there is a way to force a colum (Budget) to bring values according to selections, but exclude certain selections, like Employee in this case?

Thank you for the assistance.

Re: Excluding specific Dimension

sujeetsingh — Thu, 13 Dec 2012 08:36:04 GMT

Hi,

Just use following expression for Budget

sum({$<Employee=>} aggr( Budget , Month,Customer,Budget))

Hope it works!

Re: Excluding specific Dimension

hschultz — Thu, 13 Dec 2012 08:39:59 GMT

Unfortunately that doesn't work

Re: Excluding specific Dimension

sujeetsingh — Thu, 13 Dec 2012 08:53:58 GMT

Why are you using aggregate

Re: Excluding specific Dimension

sujeetsingh — Thu, 13 Dec 2012 08:56:24 GMT

Hi,

Please use this as expression

=sum({$<Employee=>}Budget)

hope it is welll

Do reply...

Re: Excluding specific Dimension

hschultz — Thu, 13 Dec 2012 08:57:44 GMT

For the month's to combine the sum accordoing to selection.

*Please note this is an example from a bigger model, and we originally tested normal sum() but it didn't calculate correctly

Re: Excluding specific Dimension

hschultz — Thu, 13 Dec 2012 09:14:26 GMT

Yes this works fairly well, and in fact i think as well as it's going to...

But the core functionality of QV kind of negates what i'm trying to achieve, because then the month's available goes according to the employee selected.

Thanks for the response though, i will test a few settings with what you have given me.

Re: Excluding specific Dimension

sujeetsingh — Thu, 13 Dec 2012 09:18:45 GMT

If all going well then just End up the thread...by the "correct answer" title.

You are welcome.

Re: Excluding specific Dimension

hschultz — Thu, 13 Dec 2012 09:21:00 GMT

Will be testing a few more settings, then i will respond appropriately. But you have been helpful so far thank you

Re: Excluding specific Dimension

sujeetsingh — Thu, 13 Dec 2012 09:58:56 GMT

No issue..