Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
psk180590
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
maxgro
MVP
MVP

Dimension

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


1.png

View solution in original post

5 Replies
sdmech81
Specialist
Specialist

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

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

Thanks Sachin

I was able to solve with the following expression

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

maxgro
MVP
MVP

Dimension

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


1.png

View solution in original post

sdmech81
Specialist
Specialist

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