Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sumit2504
Contributor III
Contributor III

Working days in Filterpane

Hi All,


I want to display Working days in a filter pane.

For example, in April we have 22 working days so it should show 1 to 22 in Filter pane.
Is there any way to achieve.
I tried using Networkdays but it's giving me Count of working days not list one.

@tresesco 

Regards,

Sumit

3 Replies
Dalton_Ruer
Support
Support

I am not sure what you mean. If you want to filter something, you will need to have a field in your data set that will be filtered. So for each date in your data, you need to do something that converts the date "4/1" into 1, and "4/5" into 3. Then that is the field you would use in the Filter. If you simply create something on the fly that shows 1-22, that is called a Data Island and it wouldn't reduce your data in any way. Meaning if you clicked 3, it would have no idea that you want to limit the data to 4/5/2021.

Sumit2504
Contributor III
Contributor III
Author

Thanks for your reply.

I'm attaching an image, I've a DATE field and I want to create working day field which you can see on right side of attachment.

 

Sumit2504
Contributor III
Contributor III
Author

Can anyone help on this request?