Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MCmiranda
Contributor II
Contributor II

Extra field in data upload

Hi there,

Can someone push me in the right direction, or give me an example by telling me a solution?

So, I make an Excel export from a program and upload this to QS.
In this file I have 3 columns with different end dates. I need a new column with one absolute end date
based on the type of workorder it is.
For example:
When [workorder] = A, then copy the date from [date1] to a new field: [absolute end date]

I want to use this extra column/field in all my diagrams, not just in 1 table.

Hope I make myself clear..

If someone know a YouTube video for something like this, already a very big help!

 

Labels (3)
4 Replies
Ksrinivasan
Specialist
Specialist

hi,

in your load script add this line

if([workorder] = 'A',date1,'') as [absolute end date]

ksrinivasan.

MCmiranda
Contributor II
Contributor II
Author

Thank you!

Will this script add a column (the absolute end date column) if there is no current column with this name?

Ksrinivasan
Specialist
Specialist

hi,

yes, extra new column will add,

ksrinivasan

MCmiranda
Contributor II
Contributor II
Author

The first comma is red, after that it is red shadow. Is it possible that I cannot use , ?