Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cpalbrecht
Contributor

Fill gaps in pivot table

I have the following pivot table:

pivot_table.JPG

Each row represent a specific state. The states are grouped. Each column is a timestamp.

Let's take the group "operational_status". At 09:52:30.273 the operational state changed to converter, isolation_monitor and safety_relay. And at 09:52:39.784 the state changed again to converter and safety_relay.

Now I want to have the first state change for each timestamp until the next state change and so on. For that example I want to have the first state (converter, isolation_monitor and safety_relay) for each red marked column.

Tags (2)
1 Reply
Digvijay_Singh
Honored Contributor III

Re: Fill gaps in pivot table

If these red mark values are null then may be something like this in the expression of values shown for timestamp, I assume timestamp value is a kind of flag value, helping to color specific cells.

if(len(timestampvalue)=0,before(timestampvalue),timestampvalue)

Community Browser