Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Mayank_Mohan
Partner - Contributor II
Partner - Contributor II
‎2022-01-17 01:01 AM

YTD & MTD in Filter pane

Hi ,

I want to put the YTD & MTD on the filter pane , such that all the other charts/visualization in the sheet change as I filter it through the filter pane . 

Please help me with this !

Thanks 

Labels (6)
910 Views
0 Likes
1 Solution

Accepted Solutions
PrashantSangle
MVP
MVP
‎2022-01-17 01:37 AM

Create inline table in script like

Load * Inline [

Measure

YTD

MTD

];

and use that measure field as filter in front end

and in chart you can use if(getfieldSelections(Measure)="YTD",YTDExpression,MTDExpression)

 

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

860 Views
1 Reply
PrashantSangle
MVP
MVP
‎2022-01-17 01:37 AM

Create inline table in script like

Load * Inline [

Measure

YTD

MTD

];

and use that measure field as filter in front end

and in chart you can use if(getfieldSelections(Measure)="YTD",YTDExpression,MTDExpression)

 

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
861 Views