topic Re: If-Function instead of number in QlikView

If-Function instead of number

dominicanlauf — Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody,

I have a question regarding a function that I have set up to record all the production operations of a lathe until 19 o'clock. Now I don't want to record until 19 o'clock, but as long as the machine is operated by production staff.

This information is stored in an event log. If the machine.event = 'manned', the machine.event.end should be used as the end time (at the position of 19). The current function is:

sum ({<LatheStatistics.START_TIME = {"= hour (LatheStatistics.START_TIME) <19"}>} LatheStatistics.END_TIME-LatheStatistics.START_TIME) * 24

How should I phrase the expression if I want : if (machine.event = "manned", hour (machine.event.end)) instead of 19?

Many Thanks,

Dominic

Re: If-Function instead of number

Anil_Babu_Samineni — Fri, 03 May 2019 13:26:19 GMT

Do you mean this?

sum ({<LatheStatistics.START_TIME = {"= hour (LatheStatistics.START_TIME)<if (machine.event = "manned", hour (machine.event.end))"}>} LatheStatistics.END_TIME-LatheStatistics.START_TIME) * 24

sum ({<LatheStatistics.START_TIME = {"=if (machine.event = "manned", hour (machine.event.end))"}>} LatheStatistics.END_TIME-LatheStatistics.START_TIME) * 24

Re: If-Function instead of number

dominicanlauf — Mon, 06 May 2019 07:15:12 GMT

Thanks for replying!

I mean the first variant.

But it doesn't work at all!

Re: If-Function instead of number

Anil_Babu_Samineni — Mon, 06 May 2019 09:54:30 GMT

When you say, It is not working. My suggest would explain way like

1) Where it is not working

2) What it is not working

3) If this expression says okay, Does values are not matched?

etc.

Re: If-Function instead of number

dominicanlauf — Mon, 06 May 2019 11:20:15 GMT

My fault, it works!

Thank you!