Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
himabinduch
Creator
Creator
‎2018-09-22 06:12 AM

Data issue after exporting

HI All,

I have a  straight table in my application and i have huge data.

when i am exporting data to excel i am facing some issue my data

one of the text field convert into date format.

my data as below. mu line number suppose to be 1-4,1-3,1-2  like that.

 

order#Line numberchange dateoperating unitchange by name
8346801-Apr########QTIL OUNCHOU
8346801-Apr########QTIL OUNCHOU
8346801-Apr########QTIL OUFEEDER SYSTEM
8346801-Apr########QTIL OUFEEDER SYSTEM
8346801-Apr########QTIL OUFEEDER SYSTEM
8346801-Apr########QTIL OUFEEDER SYSTEM
8383901-Mar########QTIL OUSHERRYL
8383901-Mar########QTIL OUSHERRYL
8383901-Mar########QTIL OUFEEDER SYSTEM
8383901-Mar########QTIL OUFEEDER SYSTEM
8383901-Mar########QTIL OUFEEDER SYSTEM
8383901-Mar########QTIL OUFEEDER SYSTEM
8428771-Mar########QTIL OUC_LHE
8428771-Mar########QTIL OUFEEDER SYSTEM
8428771-Mar########QTIL OUKANDY
8428771-Mar########QTIL OUC_LHE
8428771-Mar########QTIL OUC_LHE
8428771-Mar########QTIL OUFEEDER SYSTEM
8428771-Mar########QTIL OUFEEDER SYSTEM
8428771-Mar########QTIL OUFEEDER SYSTEM
8428771-Mar########QTIL OUFEEDER SYSTEM
8428771-Apr########QTIL OUKANDY
8428771-Apr########QTIL OUC_LHE
8428771-Apr########QTIL OUFEEDER SYSTEM
8428771-Apr########QTIL OUFEEDER SYSTEM
8428771-Apr########QTIL OUFEEDER SYSTEM
8428771-Apr########QTIL OUFEEDER SYSTEM
8388041-Nov########QTIL OUKANDY
8388041-Nov########QTIL OUKANDY
83880413-1########QTIL OUKANDY
83880413-1########QTIL OUKANDY
8420901-Apr########QTIL OUCONNIEK
8420901-Apr########QTIL OUCONNIEK
8420901-Apr########QTIL OUFEEDER SYSTEM
1,309 Views
0 Likes
1 Solution

Accepted Solutions
rakeshkumar1890
Creator
Creator
‎2018-09-22 12:53 PM

Put on your dimension like that - Double Quote with space and your field name

" " &[Line number]

View solution in original post

1,200 Views
0 Likes
5 Replies
trdandamudi
Master II
Master II
‎2018-09-22 12:16 PM

Did you tried to select "Number" or " Expression Default" in the Number tab ?

1,200 Views
0 Likes
rakeshkumar1890
Creator
Creator
‎2018-09-22 12:53 PM

Put on your dimension like that - Double Quote with space and your field name

" " &[Line number]

1,201 Views
0 Likes
shiveshsingh
Master
Master
‎2018-09-23 05:34 AM

Change the format of that column to Text.

1,200 Views
0 Likes
himabinduch
Creator
Creator
‎2018-09-24 08:03 AM
Author

In response to rakeshkumar1890

Hey it worked for me

1,200 Views
0 Likes
rakeshkumar1890
Creator
Creator
‎2018-09-24 11:03 PM

In response to himabinduch

I think, you got your result, if ok please close this thread.

also you can use it

text([Line number])

1,200 Views
0 Likes