Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
priyarane
Valued Contributor

Decimal extract in Script

Hi Community,

we have many fields with decimal data like below. But when we store into csv by STORE, decimal data is missing. Is there any way we can handle it.

Here I am expecting we have to handle more than 30 columns and in the script only.

Ex: Data

Field1

0

0.2

0.3

 

3 Replies
priyarane
Valued Contributor

Re: Decimal extract in Script

Any ideas?
Support
Support

Re: Decimal extract in Script

What would be most helpful in trying to help you is a sample qvw along with the resulting QVD you create from that, so we can check both sides of things here.  Do not really have any suggestions based upon what you have told us thus far, apologies.

Regards,
Brett

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Partner
Partner

Re: Decimal extract in Script

It is hard to send you general advice on this problem, maybe you could reproduce it into a simple QlikView or Qlik Sense file that you could share?

One thought I had. Are the rest of your columns correct? Could it be that you are storing data with comma separated decimal into a comma separated csv file?

The table below

Field1, Field2, Field3
0.1, 0,1
0.2, 0,2
0.3, 0,3

Will result in Field2 having all zeros and Field3 having 1, 2 and 3.
Please ekskuse my Norglish and Swenglish typos.