Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Use Set Analysis

hi,

How transpormar following expression to set analysis ? For the exposed form generates the incorrect value, why not obey selection of products.

sum (if (ProductName = 'CAPPUCPRONTO'), Vol_Umb/12, Vol_Kg)

Thank you!

2 Replies
shree909
Valued Contributor II

Re: Use Set Analysis

Hi use this

=sum ({<ProductName ={'CAPPUCPRONTO'}>} Vol_Umb/12, Vol_Kg)

is 

Vol_Umb/12, Vol_Kg is one filed or 2 fields...  for one field it works fine

if it is 2 fields use the aggregation..

Aggr(sum ({<ProductName ={'CAPPUCPRONTO'}>} Vol_Umb/12), Vol_Kg)

if not clear please post a sample of file with fields names..

Not applicable

Re: Use Set Analysis

hi,

Are two distinct fields.

The expression did not show any results.

I managed to solve the following expression, not very elegant, but gave the correct result.

=sum({$<Nome_Familia1 = {"CAPPUCPRONTO"}>} Vol_Liq_Umb/12 ) + sum({$<Nome_Familia1 -={"CAPPUCPRONTO"}>} Vol_Liq_Kg)

Community Browser