Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

Hi All,
I am facing problem in the below mention calculation:
ProductMarketunitsHeader 4Header 5Header 6
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
9 Replies
israrkhan
Valued Contributor II

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...

Not applicable

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!

MVP
MVP

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.

Not applicable

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

Not applicable

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

Not applicable

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

Not applicable

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

Community Browser