Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

marksmunich
Contributor II

how to hide holidays in the date dimension

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.

date.jpg

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

Tags (1)
1 Solution

Accepted Solutions
marksmunich
Contributor II

Re: how to hide holidays in the date dimension

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

5 Replies

Re: how to hide holidays in the date dimension

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

Re: how to hide holidays in the date dimension

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
Valued Contributor II

Re: how to hide holidays in the date dimension

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..

Re: Re: how to hide holidays in the date dimension

Hi,

have a look at attached application.

Store holidays in a variable.

Regards

ASHFAQ

marksmunich
Contributor II

Re: how to hide holidays in the date dimension

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

Community Browser