topic Re: Problem with if statement in QlikView

Problem with if statement

bsocks_11415 — Fri, 15 Nov 2024 22:37:39 GMT

I have a dataset with current and historical daily data on an hourly basis. The current days data only exists up to current time. Because of this, when comparing the hour by hour information, my chart shows current value = 0 for any time stamp > now. I tried creating a dimension to replace the imported timestamp, but the condition is not taking. Can someone tell me where I am going wrong? The idea is that each value above hour 15 should be NULL and I can use ignore null to remove them from my line chart.

My calculated dimension (far right) is: =if(hour <= Date(Now(),'hh'), hour, NULL())

Re: Problem with if statement

edwin — Tue, 24 Aug 2021 23:46:16 GMT

you may be comparing different data types. i suggest using hour(now()) and compare it with hour(TIMESTAMPFIELD) or maybe you already extracted the hour into a number field, the hour function return an integer and will be same type

Re: Problem with if statement

Maria_Halley — Wed, 25 Aug 2021 08:59:27 GMT

@bsocks_11415 @edwin

I am moving this to the App development board for better visibility