topic Literal Value from Filter Pane in App Development

Literal Value from Filter Pane

TBQlikNewbi — Tue, 11 Jun 2019 16:01:29 GMT

I need to be able to choose "YTD" or " QTD" for an application, and then have the charts on the sheet reflect the appropriate date ranges for those values. I was going to try and use ValueList and literals (e.g. ValueList('YTD','QTD')) in a filter pane, but when I do that, the selection doesn't seem to go anywhere, because it's not in the data model. Any suggestions?

Re: Literal Value from Filter Pane

JordyWegman — Wed, 12 Jun 2019 09:57:51 GMT

Hi,

First, do you have a calendar in your data model?

If you don't, create one. If you do, create two indicators YTD and QTD

if(date(Date,'MMDD')&'' <= date($(vToday),'MMDD') & '',1,0) as _indYTD, if(date(Date,'QQDD')&'' <= date($(vToday),'QQDD') & '',1,0) as _indQTD,

Use these indicators as Set Analysis in your formulas in your charts.

Make then a variable that you can switch between YTD and QTD.

Jordy

Climber