Based on Filter Selection Show condition

[kiranpatil123]

Hi All , 

I have the filter ( field ) called "Week " and it contains data like
Year-Weekno-Month

2019-Week 1 -Jan

2019-Week 2-Jan

Requirement is based on the selection of the filter ( Week ) in  new  text box i need Dates of the Week to be shown  

Ex - If 2019-Week1-Jan is selected , then it needs to be shown 1 , 2 , 3, 4 , 5 , 6, 7 ( Dates of Jan 1st week )

I tried giving 

if(Getfieldselection(Week),Date( createddate ))

I know its some where between getfieldselection , but not able to execute it ( Let me know if any other way )  

Advance thanks

[Vegar · Accepted solution]

I would use getselectedcount() instead. https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Field...

if(getselectedcount(Week)>0, concat(day(createddate), ', ') )

[kiranpatil123]

Thanks a lot worked 🙂
Just added distinct to my solution