Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
What exactly are you trying to do? Can you share some data to show what you have and what you intend to do?
Thanks Sunny for your reply !
'' Status '',
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 .
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?
Thanks for your reply !
Yes so you mean something like this :- ?
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 :-
Ya, does that work?
Thanks it works Sunny !