topic Re: Two values as one in Bar Chart in QlikView

Two values as one in Bar Chart

psk180590 — Sat, 11 Feb 2017 10:42:50 GMT

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 — Sat, 11 Feb 2017 11:35:18 GMT

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 — Sat, 11 Feb 2017 12:02:24 GMT

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 — Sat, 11 Feb 2017 12:03:51 GMT

Thanks Sachin

I was able to solve with the following expression

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

maxgro — Sat, 11 Feb 2017 12:05:29 GMT

Dimension

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

sdmech81 — Sat, 11 Feb 2017 12:40:40 GMT

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