Calculated Dimension help

Anonymous — Mon, 06 Jun 2011 19:06:35 GMT

Hello All,

I don’t have access to my qvw script however, I am trying to create a calculated dimension that uses a flag (Y/N) to determine a qualifying category based off the Customer. I want to be able to look at the customer in a table and use the Qualifying Category to sum revenue. Here how I want the qualifying catergory to look like.

Customer,Flag,Category,Revenue,Qual_Category

1,Y,A,100,A

1,N,B,50,A

2,Y,C,100,C

2,N,D,50,C

I am able to use an if statement for the first true condition if(Flag=’Y’,Category, but trying to get the match based off of the customer is where I am having issues. Thank you

Calculated Dimension help

erichshiino — Tue, 07 Jun 2011 01:34:31 GMT

you could use aggr to create your dimension:

=aggr( if( Flag='Y', Category) , Customer, Flag))

but I didn't get the pattern to generate the Qual_Category. If you explain, we can try to write the condition..

Hope this helps for now...

Erich

topic Calculated Dimension help in QlikView

Calculated Dimension help

Calculated Dimension help