Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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?