Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading data from an xls. It has one column known as 'Final'. This column has percent as well as integer,$ value and text values. For example, it has values as follows:
Final
225.56
3456
94.25%
5% & below
When I load this data into Qliksense, all the values are converted to percentages(auto) by QlikSense while loading.
Please let me know, how can I display the actual values from Xls, i.e, i want to display percent as well as integer,$ value and text values. Pls. suggest.
Radha,
It's quite unusual thing to me but let me try to help you.
Maybe you should do this:
Load
If(Len(Trim(PurgeChar(Final,'0123456789%.')))<>0,Text(Final),
If(Match(Final,'%'),Num#(Final,'#,##0%'),Num#(Final,'#,##0'))) as NewField
From Your_Table;
Hope it helps you!
Is this question solved? If my response above was helpful please close the thread by marking it as a correct answer.
May be check this, using of Alt():
Num(Alt(Num#(Final,'#,##0%'),Num#(Final,'#,##0'),
Num#(Final,'#,##0.00')
Len(Trim(PurgeChar(Final,'0123456789%.')))<>0,Text(Final)))as Final.
Tweak some modifications on above expr.