Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jleefjcapital
Contributor

I would like to collapse the null values in my timeseries

Hi everyone,

I have reassigned data points from a field called [value] into two separate data points called [Alabama_NF_thous] and [Alabama_3m_thous]. 

When I add both series to the table, I get duplicate dates.  Is there a way to collapse the fields so that there's only 1 date per data point?   Here's a screenshot of what I'm seeing--

3 Replies
xufei123
Valued Contributor

Re: I would like to collapse the null values in my timeseries

If you only want to do it in the front you can change [Alabama_NF_thous] and [Alabama_3m_thous] from dimension to Measure (sum them up).

Or you can do it in the script (sum them up and group by dimensions)

Fei

ogster1974
Honored Contributor II

Re: I would like to collapse the null values in my timeseries

Click exclude null values on your dimension might sort it.

jleefjcapital
Contributor

Re: I would like to collapse the null values in my timeseries

I was able to resolve the issue using the group by statement. 

Community Browser