Strange Extract Issue - Different Data

[#1]

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

[rwunderlich]

Do you map them to Dual() values or text values?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[vinieme12]

Can you post the line where you do applymap?

Or does  the table make use of a different calculated dimension??

[sudeepkm]

It would be helpful if you could share a sample file. by the way what are the dimension and expressions used in this chart?

[#5]

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,

[vinieme12]

then use Maxstring(NAME) in your table

[rwunderlich · Accepted solution]

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

http://masterssummit.com

http://qlikviewcookbook.com