Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Strange Extract Issue - Different Data

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

1 Solution

Accepted Solutions
rwunderlich
Luminary Alumni
Luminary Alumni

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

View solution in original post

6 Replies
rwunderlich
Luminary Alumni
Luminary Alumni

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

vinieme12
Champion II
Champion II

Can you post the line where you do applymap?

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

sudeepkm
Specialist III
Specialist III

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

Not applicable
Author

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
Champion II
Champion II

then use Maxstring(NAME) in your table

rwunderlich
Luminary Alumni
Luminary Alumni

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

View solution in original post