topic Re: Pick the distinct or first value in QlikView

Pick the distinct or first value

help4qv123 — Mon, 27 Jul 2015 05:32:32 GMT

I need only the hrs....For eg:

1:00 it is 1hr, 1:30 it is showing 1hr which is wrong......so i need only the hours or it may like a distinct value...

Please check the sample attached.

Expected Result in Yellow.

Re: Pick the distinct or first value

PrashantSangle — Mon, 27 Jul 2015 05:36:52 GMT

Hi,

In this case you can try

subfield(timefield,':',1) as Hour

Regards

Re: Pick the distinct or first value

help4qv123 — Mon, 27 Jul 2015 05:40:49 GMT

I tried the same. Its not working.

Re: Pick the distinct or first value

help4qv123 — Mon, 27 Jul 2015 05:42:57 GMT

Wat you wrote is to bring the hours in 1 column. What i need is it should display only once when it is hours. When there is minutes added. It should not show. See the image attached .

Re: Pick the distinct or first value

jonathandienst — Mon, 27 Jul 2015 05:48:05 GMT

Perhaps you need to explain your requirements in more detail. To get the time without the minutes, you could use max dreamer's suggestion above, or something like:

Round(timefield * 24, 1) & ' hrs'

or better still:

Dual(Round(timefield * 24, 1) & ' hrs', Round(timefield * 24, 1))

Re: Pick the distinct or first value

Kushal_Chawda — Mon, 27 Jul 2015 06:00:37 GMT

Please see the attached.

This is what you are looking for?

Re: Pick the distinct or first value

help4qv123 — Mon, 27 Jul 2015 06:08:11 GMT

Hi Jonathan,

Thanks for your help. But the result which i am getting from you expression is which i already got.

My output should be

currently which i am getting is

I need the repeated 0hr,1hr, 2hr ....it should be shown 1ce. Like if there is any minute in before column then dont need that....

Re: Pick the distinct or first value

Kushal_Chawda — Mon, 27 Jul 2015 06:24:33 GMT

help4qv123‌ have you checked the application which I attached?

Re: Pick the distinct or first value

help4qv123 — Mon, 27 Jul 2015 06:29:04 GMT

no were u have sent

Re: Pick the distinct or first value

help4qv123 — Mon, 27 Jul 2015 06:31:21 GMT

Yes exactly...Thank You...can you remove the 0hrs.....

Re: Pick the distinct or first value

Kushal_Chawda — Mon, 27 Jul 2015 06:54:43 GMT

Like this?

Re: Pick the distinct or first value

help4qv123 — Mon, 27 Jul 2015 07:01:31 GMT

Thank You Bro. Have not In another way.

Thanks.