topic Re: condition in QlikView

condition

master_student — Thu, 22 Sep 2016 16:23:01 GMT

Hello guys,

Hope you are very well

I have an expression : =Hour(Date(TIME/1440,"hh:mm:ss"))&'H:' &Minute(Date(TIME/1440,"hh:mm:ss"))&'Min'

The result of this exp is a duration, something like that : 1H:25Min

I need to add a condition if the result > 30Min => display 30 Min, if not display the result

Any idea please.

Thanks

Re: condition

robert_mika — Thu, 22 Sep 2016 16:33:07 GMT

Try:

if(Minute(Date(TIME/1440,"hh:mm:ss"))>30,30&'Min',

Hour(Date(TIME/1440,"hh:mm:ss"))&'H:' &Minute(Date(TIME/1440,"hh:mm:ss"))&'Min)

Re: condition

el_aprendiz111 — Thu, 22 Sep 2016 16:38:38 GMT

hi,

=if(frac(Hour(Date(now()/1440,'hh:mm:ss')))<30,'New Mssg',Hour(Date(now()/1440,'hh:mm:ss'))&'H:' &Minute(Date(now()/1440,'hh:mm:ss'))&'Min')

Re: condition

sunny_talwar — Thu, 22 Sep 2016 16:49:53 GMT

Or this:

If(TIME >30, '30 Min', Hour(TIME/1440) &'H:' & Minute(TIME/1440) &'Min')

Re: condition

MarcoWedel — Thu, 22 Sep 2016 20:49:04 GMT

Hi,

so you want to limit your formatted time field to 30Min, right?

Maybe one way to do so might be:

table1:
LOAD *,
    Replace(Time(RangeMin(TIME,30)/1440,'h@mm')&'Min','@','H:') as TimeLimit30Min,
    Hour(Date(TIME/1440,'hh:mm:ss'))&'H:' &Minute(Date(TIME/1440,'hh:mm:ss'))&'Min' as YourExpression;
LOAD RecNo()-1 as TIME
AutoGenerate 1440;

hope this helps

regards

Marco

Re: condition

MarcoWedel — Thu, 22 Sep 2016 20:56:20 GMT

or as the hour of a time < 30Min will always be 0:

'0H:'&RangeMin(TIME,30)&'Min'

or without '0H:' in the 30Min case:

If(TIME<30,'0H:')&RangeMin(TIME,30)&'Min'

hope this helps

regards

Marco