Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Straight Table Null Handling

Hi Experts,

Can any one please help me to resolve the below issue.

I have three fields named issuenum,Submission Date and Approval Date.

I have derived Submission Date and Approval Date fields from Name and Value fields with below expressions.

=  Aggr(Only({<name = {'Submission Date'}>} Value), Value)

=  Aggr(Only({<name = {'Approval Date'}>} Value), Value)


Then after I have taken these fields in Straight table Dimensions lbut getting three duplicate rows.

Is there any way to show these records in one row instead of three rows, in UI. Please help me on this.


Thanks in advance.


1 Solution

Accepted Solutions

Re: Straight Table Null Handling

All three of them are coming as a dimension? May be this?

=Aggr(Only({<name = {'Submission Date'}>} Value), issuenum)

=Aggr(Only({<name = {'Approval Date'}>} Value), issuenum)

2 Replies
nagaiank
Valued Contributor III

Re: Straight Table Null Handling

You may try the following:

NewTable:

NoConcatenate

load issuenum, Concat([Submission Date],'') as [Submission Date],Concat(Approval,'') as Approval

resident (your original table name here)

group by Iisuenum;

Drop Table (your original table name);

Re: Straight Table Null Handling

All three of them are coming as a dimension? May be this?

=Aggr(Only({<name = {'Submission Date'}>} Value), issuenum)

=Aggr(Only({<name = {'Approval Date'}>} Value), issuenum)

Community Browser