topic Re: How NOT TO TAKE into account dimension in QlikView

How NOT TO TAKE into account dimension

sculptorlv — Tue, 02 Feb 2016 13:19:09 GMT

I have two dimension Client and Contract, and some Money values.

I have to decide, if Client is high money or low money ... like in right picture.

Then I need to add another dimension Contract for another calculations, but in Test expression I have to avoid it somehow.

Is it possible NOT TO TAKE into account selected dimension in expression?? (left picture)

Something like AGGR function, but without chosen dimension.

P.S.: based on my previous problem

Re: How NOT TO TAKE into account dimension

MK_QSL — Tue, 02 Feb 2016 13:35:24 GMT

Provide more information please ... Your description is not giving proper idea what exactly you want !

Re: How NOT TO TAKE into account dimension

sunny_talwar — Tue, 02 Feb 2016 13:36:38 GMT

You want to see Values in just one of those rows?

Try this:

Aggr(TestExpression, Client)

Re: How NOT TO TAKE into account dimension

sculptorlv — Tue, 02 Feb 2016 13:39:39 GMT

I use this AGGR, but ...

If I have dimension Contract, it calculates based on Client AND on Contract - as the result different result

I need to get calculation based only on Client dimension (like on right picture), but I need to show dimension Contract in this table ... so for each contract should be taken calculation based on other dimension - Client (not Contract)

Re: How NOT TO TAKE into account dimension

gsbeaton — Tue, 02 Feb 2016 13:41:31 GMT

Hi Ruslans,

Yes, it is possible to avoid the 'chosen dimension' using set analysis. You would just have to so something like this

Count({$<[ChosenDimension]=>} [Contract Number])

By using the '=' without a search parameter, you cancel that selection.

Hope that helps. If not, please post more details on your problem.

Cheers

George

Re: How NOT TO TAKE into account dimension

sunny_talwar — Tue, 02 Feb 2016 13:41:53 GMT

I think, like Manish mentioned, it would be easier to understand your issue if you are able to share a sample.

Re: How NOT TO TAKE into account dimension

jonathandienst — Tue, 02 Feb 2016 13:47:57 GMT

I think this is what you are after - use a qualified TOTAL, like

Sum(TOTAL <Contract> Value)

This will ignore the Contract dimension.

Re: How NOT TO TAKE into account dimension

sculptorlv — Tue, 02 Feb 2016 13:52:25 GMT

I think it is exactly what i wanted.

Thank you ... will test now.

Later..

This really works. My code is:

SUM(

TOTAL <Sales_Agent_Name> (

(if(Sale_Category = 5.2, Sale_Money, 0))))