how to hide holidays in the date dimension

[marksmunich]

Hello community, I am using the Dimension date in a a straight table and barchart, Here I would like to hide the Holidays. how this can be implemented.

for example I want to hide saturday and sunday. this is about the future forecast.. since we can see the future days.

any suggestions or tips.

thanks

Mark

[alexandros17]

There is the function NetWorkingDays() , but to manage a lot of dates it is better to add a list (XLS) of dates to be excluded and add a flag in your calendar during the loading and use that flag in the chart

Let me know

[marksmunich]

networkdays return the total working days in a time interval. but Here i just want to hide the Dates. I think flags concept work. Is there any other possibility.

[israrkhan]

i think you will not have data for holidays???

if so, you can check suppress null value, or you can try calculated dimension..where you will show the dates that does not have values, like holidays..

[ashfaq_haseeb]

Hi,

have a look at attached application.

Store holidays in a variable.

Regards

ASHFAQ

[marksmunich · Accepted solution]

hi all,

Problem solved I used a simple if condition to hid These values. weekday function on the date field will try to find if it is a weekday or Weekend. In this case ist production. so it is 7 days a week.

Thanks all