Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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:
Thanks Sachin
I was able to solve with the following expression
=If(Produkt='Rest'or len(Produkt)=0,'Rest',Produkt)
Dimension
=if(IsNull(Product) or Product='Rest', 'Rest', Product)
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