Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
nagarajuecs
New Contributor

Data Formatting issue while storing the data into QVD

Hi Team,

We are facing an issue with the data formatting while storing this data to QVD. We need the exact data whatever we have in the database. for example, the date column has data  like

Date:

2018-02-03T10:22

2018-03-04

2018-04-05T05:00

2018-06-07

When you observe the above data, it has different formats and the same data should be stored in QVD. But, when we load this data to QVD, it's converted to single format based on the first value and the output data stored in QVD as below (Appended timestamp to it).

Date:

2018-02-03T10:22

2018-03-04T00:00

2018-04-05T05:00

2018-06-07T00:00 which is not expected.

Currently, we handled this issue by using text(Date) and we have many date columns. Similarly, we have to handle this for different variables. Why Qlik can't store this as it is?

I feel it's an issue in the Qlik. Feel free to add your comments.

Regards,

Nagaraju

 

4 Replies
shiveshsingh
Honored Contributor

Re: Data Formatting issue while storing the data into QVD

Try this while loading in script in qlikview

 

Text(Date) as Date

pradosh_thakur
Honored Contributor II

Re: Data Formatting issue while storing the data into QVD

We have a variables defined in Qlik which is creating the issue for you. You have two option to tackle this.

1:  Change the variable defination

2: Use text(field) as sugested

Learning never stops.
nagarajuecs
New Contributor

Re: Data Formatting issue while storing the data into QVD

We used text() to handle this issue. But, we have multiple date columns and in this case, we have to apply the same function across. Do you know the reason why it's doing the conversion in QVD?

MVP & Luminary
MVP & Luminary

Re: Data Formatting issue while storing the data into QVD

If you want to have multiple formattings for the fieldvalues within a field you need to load them with the formattings, maybe with something like:

alt(date(date#(Field), 'format'), 'format'), timestamp(timestamp#(Field), 'format'), 'format'))

Further it might be useful to split such timestamp into a date- and a time-field and just to add them together again where it's really needed. Such an approach would simplify some tasks and could save a significantly amount of resources, see: The-Importance-Of-Being-Distinct.


- Marcus