Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a field in QlikView that starts with raw data 1, 2 and 3. I use an applymap to convert this into High Medium and Low.
Now when a user sees the table shes sees high medium and low. however when she extracts this to excel using the XL button its gets turned into 1,2 and 3. Im pretty sure the 1,2 3 data isnt even in the system so I have no idea how this is happening. I have been unable to reproduce the issue for myself.
Has anyone encountered a similar issue?
Many thanks
Makes sense, You are probably using Dual() to get a numeric for sorting. It's the numeric value that will be exported. As Viineeth suggested, use maxstring() or text() in the chart Expression. For sorting, you can sort by expression "num(Field)"
-Rob
Do you map them to Dual() values or text values?
-Rob
Can you post the line where you do applymap?
Or does the table make use of a different calculated dimension??
It would be helpful if you could share a sample file. by the way what are the dimension and expressions used in this chart?
Turns out its using dual() - Should I try and use text values instead?
Map_x:
MAPPING LOAD
ID,
dual(Name, if(Name = 'High', 1, if(Name = 'Low', 3, 2))) as Name;
ApplyMap('Map_x, RiskGradingID, null()) as Field,
then use Maxstring(NAME) in your table
Makes sense, You are probably using Dual() to get a numeric for sorting. It's the numeric value that will be exported. As Viineeth suggested, use maxstring() or text() in the chart Expression. For sorting, you can sort by expression "num(Field)"
-Rob