Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Set Analysis

Hello,

Please help me to get correct logic

 

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

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Thanks For Response

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

 

View solution in original post

6 Replies
Highlighted
Creator III
Creator III

what error are you getting

Highlighted
Creator II
Creator II

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

Highlighted
Creator III
Creator III

Try this

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

Highlighted
Creator II
Creator II

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.

Highlighted

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.

Highlighted
Creator II
Creator II

Thanks For Response

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

 

View solution in original post