topic Hi, everyone in QlikView

Hi, everyone

Fri, 06 Apr 2012 06:59:00 GMT

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, everyone

Jason_Michaelides — Fri, 06 Apr 2012 07:02:19 GMT

Have you tried wrapping the expression in Text() in the QlikView table?

Hi, everyone

Fri, 13 Apr 2012 09:33:11 GMT

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.

Hi, everyone

Jason_Michaelides — Fri, 13 Apr 2012 09:37:22 GMT

Can you post your app?