Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor III

Two values as one in Bar Chart

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!!

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Two values as one in Bar Chart

Dimension

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


1.png

View solution in original post

5 Replies
Highlighted
Valued Contributor

Re: Two values as one in Bar Chart

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

Highlighted
Valued Contributor

Re: Two values as one in Bar Chart

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:

Highlighted
Contributor III

Re: Two values as one in Bar Chart

Thanks Sachin

I was able to solve with the following expression

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

Highlighted
MVP
MVP

Re: Two values as one in Bar Chart

Dimension

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


1.png

View solution in original post

Highlighted
Valued Contributor

Re: Two values as one in Bar Chart

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