Two values as one in Bar Chart

[psk180590]

Hello All,

I have some results stored in a QVD as follows

Product                    Sales

     A                           100

     B                           200

     C                           500

      -                           600

     D                           800

     Rest                       900

I would like to display all these values in a bar chart, but i would want ''Rest' and '-' to be calculated and displayed together as  'Rest'.

PS: The product '-' are the values which have no product i.e; this are null values which are converted to '-' by Qlik.

TIA!!

[sdmech81]

Hi,

Go to calculated dimensions.

Add something like:

If (product=null() or rest,'Rest', product))

Then u add expression as sum(sale)

Plss try..hope it helps..

Sachin

[sdmech81]

HI, Ignore first reply

plss find the attached QVW and excel,you can find the solution thr

Try in calculated dimension like:  =IF(IsNull(Product) or Product='Rest','Rest',Product)

and expression as :  Sum(sales)

u can find calculated dimension in dimension tab..attaching screen shot:

[psk180590]

Thanks Sachin

I was able to solve with the following expression

=If(Produkt='Rest'or len(Produkt)=0,'Rest',Produkt)

[maxgro · Accepted solution]

Dimension

=if(IsNull(Product) or Product='Rest', 'Rest', Product)

[sdmech81]

Hi,

Cool, it should work fine

But what if there is space in place of null() and  still u want to merge those in REST,i mean if excel is source thn its possible.

Better say like:  len(trim(Product))=0  in above expression.

Thanks