Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

View solution in original post

3 Replies
MVP & Luminary
MVP & Luminary

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

View solution in original post

Creator III
Creator III

Hi,

   Can You please provide Sample Data.

Regards

Not applicable

Thank you!