9 Replies Latest reply: Jul 28, 2013 2:49 AM by Kaushik Solanki

How to Ignore field selection which is in dimension using set analysis

Hi All,
I am facing problem in the below mention calculation:
A1A

207454

A2A5457
A3A457
A4A356
A5A5724
B1B2457
B2B4577
B3B23475
C1C756
C2C754275
C3C324
C4C57425
C5C4257
C6C547547
Now I have a straight table in QlikView wherein my dimension is: If(Product='A1' or Product='B1' or Product='C1', Product) so that it shows only three products
and my expression for market share is sum({<xyz>} units / Aggr(sum({<xyz>}units),Market) and it works absolutely fine, but the moment I select any particular brand(Say A1) in the list box then the denominator of the expression returns value only for the selected product and for other two markets/products it becomes ZERO.
It will be of great help if anyone can help me out.
Regards
Sagar Gupta
• Re: How to Ignore field selection which is in dimension using set analysis

Hi,

if you want to discard the selections than Use. 1

sum(1{<xyz>} units / Aggr(sum(1{<xyz>}units),Market),

if want to discard the Dimension then use total keyword like below

sum({<xyz>} total units / Aggr(sum({<xyz>} total units),Market),

Hope it help...

• Re: How to Ignore field selection which is in dimension using set analysis

Hi Usman,

I tried what you suggested but its not working in this case. :-(

Regards

Sagar

• Re: How to Ignore field selection which is in dimension using set analysis

Hello Sagar

Use Dimension plus equal like "sum({<Dimension=>} expression)".

It will sum the expression ignoring the defined dimension.

Hope it helps!

• Re: How to Ignore field selection which is in dimension using set analysis

Hi Leo,

I have already done this and it is not working. I am not getting the values for excluded products the moment I select Product.

Note: I am getting correct value for the selected Product in the table.

Regards

Sagar Gupta

• Re: How to Ignore field selection which is in dimension using set analysis

Hi,

If you DimensionName= in an expression, then the set analysis expression doesn't consider the selections of that particular Dimension.

Sum({<DimensionName=>} Sales)

Regards,

Jagan.

• Re: How to Ignore field selection which is in dimension using set analysis

No dude Its not working. I tried all the above mentioned syntax. :-(

Regards

Sagar

• Re: How to Ignore field selection which is in dimension using set analysis

Dear Sagar,

If you want to see only the 3 Products which are A1,B1 and C1 then the better idea is to create a field in script instead of using the if statment in the dimension.

Try this, this might solve your problem.

Regards,

Kaushik Solanki

• Re: How to Ignore field selection which is in dimension using set analysis

Hi Kaushik,

Thanks for the reply. I don't think doing this will solve the problem. Yes I agree that we shouldn't use calculated dimension as it decreases the tool's performance.

Regards

Sagar Gupta

• Re: How to Ignore field selection which is in dimension using set analysis

Dear Sagar,

Give it a try and see whether it works or not.

Regards,

Kaushik Solanki