Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jleefjcapital
Contributor

Timeseries data: pull only dates with values for analysis

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?  

1 Reply
MVP
MVP

Re: Timeseries data: pull only dates with values for analysis

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