Discussion Board for collaboration related to QlikView App Development.
I have some results stored in a QVD as follows
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.
=if(IsNull(Product) or Product='Rest', 'Rest', Product)
View solution in original post
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..
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:
I was able to solve with the following expression
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.