Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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
Specialist
Specialist

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

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
Creator III
Creator 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
Specialist
Specialist

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