Set Analysis

[Surya]

Hello,

Please help me to get correct logic

COUNT({<FINALWEEKDAY -= {'Sun','Sat'},FINAL_FLAG = {'WORKINGDAY'}>}DATE(Today(),'DD-MM-YYYY') - ZDATE_FROM)

[Qlik1_User1]

what error are you getting

[Surya]

For eg 

01.07.2020 to 31.07.2020

here exclude holiday ,sat and sun value is 23 that's correct

Now i need to show 01.07.2020 to today that count is 17 

i Hope you understand

[Qlik1_User1]

Try this

COUNT({<FINALWEEKDAY -= {'Sun','Sat'}, FINAL_FLAG = {'WORKINGDAY'}, ZDATE_FROM= {">=$(=MONTHStart(today()))<=$(=Today())"}>} ANYDIMENSION)

[Surya]

Thanks for your responce

here  you are hardcode and apply monthstart but here we are having different starting and not apply direct monthstart at all time.

[rubenmarin]

Hi, maybe Networkdays() function canhelp you, it counts ays between dates and you can pass holidays as parameters to avoid to count them:

https://help.qlik.com/es-ES/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFu...

From your current expression, if you have a master calendar that has a field DATE with all the dates with the flags you can do something like:

COUNT({<FINALWEEKDAY -= {'Sun','Sat'},FINAL_FLAG = {'WORKINGDAY'}, DATE={">=$(=Max(ZDATE_FROM))<=$(=Today())"}>} DATE)

But this won't work if you have a table with different ZDATE_FROM because set analysis is calculated for the whole table, not row by row.

[Surya · Accepted solution]

Thanks For Response

This is Not possible in Front end and i done at back end