Recently i have updated qlikview from qv9.0 to qv11.0 ,now i have a problem when i export a pivot table report to xl if a column contains a value both numeric and text data,wherever numeric data is there am getting "number stored as text" in excel,if i changed it as number in report then am not getting any symbol like $,euro etc. with QVlik9 i dint have this problem. pls help me out. I am new to this tool. see the attached Excel for the reference
hi jason, i treid both text() and num() fn, with text() i am not getting any value,with num() fn currency symbol is not coming , i am using this expression Money(sum(if(Year=Year(today())-2,[sales] / (if(Curr_Code=vCUR_CODE,Ex_Rate)))),Only(if(Curr_Code=vCUR_CODE,Curr_Symbol))&''&'###,###,###.00;-$###,###,###.##') My requirement is the value should come in number format along with its currency symbol after exporting to excel.
