need help

[qlikapple]

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

[kevinalvino]

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

[niclaz79]

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))

[jyothish8807]

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,

KC