Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

need help

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

3 Replies
kevinalvino
Partner - Creator
Partner - Creator

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
Partner - Creator III
Partner - Creator III

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
Master II
Master II

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

Best Regards,
KC