Qlik Community

Qlik Sense App Development

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

ravishinge
Contributor

Create new field using loaded field

Hello Guys,

I needed help ....

My question is :- I have a field loaded from qvd file with all the options in it. 

For ex:- Status field which has options such as lost , win , cancelled , transferred and so on

I have used 3 options using where clause .

Now I want to use the same field (''Status'') with remaining 3 options  and dont want to alter the first 3 selected options .

I want a new field that should show remaining options if i pull it in datasheet .

How do i do this . Kindly help me with this 

6 Replies

Re: Create new field using loaded field

What exactly are you trying to do? Can you share some data to show what you have and what you intend to do?

ravishinge
Contributor

Re: Create new field using loaded field

Thanks Sunny for your reply !

Yes Sure

[Project0]:

  LOAD Distinct

   '' Status '',

FROM Project.qvd

where  ( Status = 'Lost ' or Status = 'win ' or Status ='cancelled'));


Status field has few other options such as Delayed , Past, Postponed    and so on ...

So i want to create a new field with these remaining options .

Thanks,

ravi

Re: Create new field using loaded field

The new field will be called Status_Other? and those will be concatenated to your table above? So, each row will either have Status or Status_Other?

ravishinge
Contributor

Re: Create new field using loaded field

Thanks for your reply !

Yes so you mean something like this :-  ?

concatenate

[Project2]:

LOAD

    Status as Status_Other

where (Status = 'Delayed  ' or Status = 'Past' or Status ='Postponed   '

basically what i want is new column in data sheet like this :-

Status_other

Delayed

Past

Postponed

Thanks,

Ravi

Re: Create new field using loaded field

Ya, does that work?

ravishinge
Contributor

Re: Create new field using loaded field

Thanks it works Sunny !

Community Browser