Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How show in Dimension, ONLY CLIENTS for which exist revenues

I have a straight table with:

Dimension:          Expression              Expression

CLIENTS             Total Revenues        Revenues only with Salesgroup A

Currently because I have an expression for Total Revenues, I'm getting the full list of clients in the dimension.

I'd like to list only CLIENTS which have revenues with Salesgroup A.

Is there a way to do this with set analysis in the Dimension?

Thanks in advance!

H

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: How show in Dimension, ONLY CLIENTS for which exist revenues

You can use a calculated dimension. Something like:

if(aggr(sum({<Salesgroup={'A'}>} Revenue),CLIENTS)>0,CLIENTS)

Change Salesgroup, Revenue and CLIENTS to the names of your fields.

Enable the option Suppress When Value Is Null for the calculated dimension.


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: How show in Dimension, ONLY CLIENTS for which exist revenues

You can use a calculated dimension. Something like:

if(aggr(sum({<Salesgroup={'A'}>} Revenue),CLIENTS)>0,CLIENTS)

Change Salesgroup, Revenue and CLIENTS to the names of your fields.

Enable the option Suppress When Value Is Null for the calculated dimension.


talk is cheap, supply exceeds demand
shaik_basha
Contributor III

Re: How show in Dimension, ONLY CLIENTS for which exist revenues

Hi,

   Can You please provide Sample Data.

Regards

Not applicable

Re: How show in Dimension, ONLY CLIENTS for which exist revenues

Thank you!