Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Based on Filter Selection Show condition

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

Labels (2)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

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), ', ') )
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Vegar
Partner
Partner

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), ', ') )
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

kiranpatil123
Contributor III
Contributor III
Author

Thanks a lot worked 🙂
Just added distinct to my solution