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.
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:
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.