Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Value for specific dimension if similar to another dimension

Ok, this one is giving me a hard time.

I'm trying to find a way to find the value for a dimension if it is similar to another dimension.  I have the following set Up...

image.png

So for Part 1 of my question.  How can i get only the "Member Reported Spend" for a given "Contract Name" if it matches the '=agg' column (i.e. the Spend for 3m Company for Adhesive Skin Closures - "3M COMPANY")? 

I've tried variations of sum(agg(wildmatch....and can't seem to quite get it.  Any suggestions?

2 Replies
Not applicable

Re: Value for specific dimension if similar to another dimension

Anyone have any ideas?

Re: Value for specific dimension if similar to another dimension

Post a qlikview document that demonstrates the problem you want to solve.


talk is cheap, supply exceeds demand
Community Browser