Timeseries data: pull only dates with values for analysis

[jleefjcapital]

Hello,

I have several series with differing time periods loaded in Qlik Sense.   When I drop a series into a chart, the series is pulling all of the dates, even for those with no data.

I experimented by only loading one series, and I don't have this problem, so I think I may need to adjust something on the front end of the application.

Should I create a measure?  

[sunny_talwar]

For each of the series create flags and use them in your set expression or alternatively you can use them in a calculated dimensions.

If(FlagSeries1 = 1, Date) and suppress null values on the dimensions tab.

HTH

Best,

Sunny