Discussion board where members can get started with QlikView.
I am trying to export the values like 1-2,2-3,3-4,4-5 as excel file. But, I am getting the values as 1-Feb,2-Mar,3-Apr,4-May
I have tried in script, text(field) and changed the values 1*2,2*3,3*4,4*5 and replace the * as '-'. text(replace(field),'*','-') but, I am getting the same.
help would be appreciated.
Please check, If any custom format cell applied in Excel?
Yes. Custom format is applied.
Please refer the below link and try any one of the options mentioned below.