topic Re: Set Analysis in QlikView

Set Analysis

Surya — Sat, 16 Nov 2024 00:16:29 GMT

Hello,

Please help me to get correct logic

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

Qlik1_User1 — Thu, 23 Jul 2020 06:58:25 GMT

what error are you getting

Surya — Thu, 23 Jul 2020 07:30:03 GMT

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 — Thu, 23 Jul 2020 07:45:57 GMT

Try this

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

Surya — Fri, 24 Jul 2020 05:19:58 GMT

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 — Fri, 24 Jul 2020 06:51:48 GMT

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

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 — Thu, 13 Aug 2020 06:39:11 GMT

Thanks For Response

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