topic Re: need help in QlikView

need help

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

my requirement is

in between implenting change orders(scheduled start and endtime), based on same CI , how many incidents have been opened on the same CI.

i have taken one staright table and in the expression i have writte as

=if(CHG_IN_OPEN_DATE>=SCHED_START_DATE_TIMESTAMP AND CHG_IN_OPEN_DATE<=SCHED_END_DATE_TIMESTAMP,1,NULL()) ,

which is giving correct values.

Now the user is asking one text box in which how may incidents have been opened , he needs count .

how to write in text box

Re: need help

kevinalvino — Mon, 08 Oct 2018 08:12:53 GMT

Hi Sahaja,

Just my opinion,

I think you should make a flag for the opened incidents in the edit script part.

After that, you just need to write the expression =Count("TheFlag")

Think it will be easier to manage than using set analysis to divide which one the open or close incidents inside the text box calculation.

Thanks,

Kevin

Re: need help

niclaz79 — Mon, 08 Oct 2018 08:13:54 GMT

Hi,

Will the following work?

Sum(if(CHG_IN_OPEN_DATE>=SCHED_START_DATE_TIMESTAMP AND CHG_IN_OPEN_DATE<=SCHED_END_DATE_TIMESTAMP,1))

Re: need help

jyothish8807 — Mon, 08 Oct 2018 08:17:13 GMT

Hi Sahaja,

Try this:

I believe SCHED_START_DATE_TIMESTAMP and SCHED_END_DATE_TIMESTAMP have only one value with in, else you have create a varibale and store the right dates under them and use them in the expression.

count(if(CHG_IN_OPEN_DATE>=SCHED_START_DATE_TIMESTAMP AND CHG_IN_OPEN_DATE<=SCHED_END_DATE_TIMESTAMP,incidents ID field ))

Br,