topic Re: Strange Extract Issue - Different Data in QlikView

Strange Extract Issue - Different Data

Thu, 28 Jul 2016 15:42:57 GMT

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

Re: Strange Extract Issue - Different Data

rwunderlich — Thu, 28 Jul 2016 16:55:30 GMT

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Strange Extract Issue - Different Data

vinieme12 — Thu, 28 Jul 2016 17:26:17 GMT

Can you post the line where you do applymap?

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

Re: Strange Extract Issue - Different Data

sudeepkm — Thu, 28 Jul 2016 17:28:31 GMT

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

Re: Strange Extract Issue - Different Data

Fri, 29 Jul 2016 09:02:51 GMT

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,

Re: Strange Extract Issue - Different Data

vinieme12 — Fri, 29 Jul 2016 09:29:27 GMT

then use Maxstring(NAME) in your table

Re: Strange Extract Issue - Different Data

rwunderlich — Sat, 30 Jul 2016 00:24:08 GMT

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