topic Re: Get Single Value from column in QlikView

Get Single Value from column

manojkulkarni — Sat, 02 Apr 2016 05:54:27 GMT

HI Friends,

I have below data, where in I need to get single value from a given column. How can we do this ?

Expected Out will be

215771	05-02-2016	WIP
215771	29-02-2016	PENDING

Kushal_Chawda — Sat, 02 Apr 2016 06:10:50 GMT

can you explain the logic to get the output?

manojkulkarni — Sat, 02 Apr 2016 06:15:08 GMT

If you could see the data, on a same day particular task has different status NEW & WIP. I need to get only WIP status in my new table.

Date will have time stamp as well.

Kushal_Chawda — Sat, 02 Apr 2016 06:33:47 GMT

How many total status would be there in your data?

manojkulkarni — Sat, 02 Apr 2016 06:36:42 GMT

will be 5-6 status

Sat, 02 Apr 2016 06:41:29 GMT

Hi Manoj,

Try like this

T1:

load * Inline [

ID, Date, Status

215771, 05-02-2016, NEW

215771, 05-02-2016, WIP

215771, 29-02-2016, PENDING

] Where Status<>'NEW';

may be hope ful for you.

Kushal_Chawda — Sat, 02 Apr 2016 07:21:52 GMT

So there will be combination of Status for two dates, so when to consider which status that you need to clerify

Mon, 04 Apr 2016 09:56:05 GMT

Hi,

if(Status<>'NEW',Status)

try this once.

Thanks

Tanushree Roy