topic Re: Group like Expression Results in QlikView

Group like Expression Results

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have an expression which returns the project size based upon the total net sales of another dimension:

=If([Current Net Sales]>=3,'Large Project',if([Current Net Sales]>=1,'Medium Project',if([Current Net Sales]>=.3,'Small Project','Std Dealer Pricing')))

The chart then applies this to each line:

How can I have the chart group all like results together? In the above example there would then only be 3 lines (large project, medium project, small project). When I any of the dimensions, all I get is a grand total.

Thanks!

Re: Group like Expression Results

swuehl — Wed, 01 Jun 2016 22:05:35 GMT

Try as calculated dimension:

=Aggr(

If([Current Net Sales]>=3,'Large Project',if([Current Net Sales]>=1,'Medium Project',if([Current Net Sales]>=.3,'Small Project','Std Dealer Pricing'))),

[PA Number])

and as expression something like

=Count(DISTINCT [PA Number])

Re: Group like Expression Results

Wed, 01 Jun 2016 22:27:13 GMT

You sir, just made my day. Thanks a bunch!