Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How can I prevent line reducing in a table?

Hey community

I like to have three columns as in the first table. Column Date/time is a measure, where I need to use colors for the background. The other columns are dimensions.

The filter is set to smsDelivery for e.g. 17.722 There exist two lines with this number and I like to see both. But somehow the two lines will be reduces to one and the date will be shown as '-'.

The second table works because of the field callid, which is a unique field. But I like to have the table without the callid. Is this somehow possible?

I've also added an example file.

Thanks & Regards

Sarah

table.PNG

Tags (2)
11 Replies
mwoolf
Honored Contributor II

Re: How can I prevent line reducing in a table?

You can add a field that will uniquely identify each record:

Rowno() as ID

Adding the ID column in your chart will force the rows to be separate.

aushikmakdoom
New Contributor III

Re: How can I prevent line reducing in a table?

Add the Callid as a dimension in ther report and hide the column from the presentation tab in the chart properties

Not applicable

Re: How can I prevent line reducing in a table?

It sounds more like a workaround than a real solution.

But I tried your suggestion and added a cell as meassure or dimenson with Rowno() function, but it didn't work...

table2.PNG

Not applicable

Re: How can I prevent line reducing in a table?

How can I hide a table column in Qlik sense?

mwoolf
Honored Contributor II

Re: How can I prevent line reducing in a table?

I was showing adding a new field in the load script.

Does your existing data already have a primary key? If so, use that field instead of creating one.

aushikmakdoom
New Contributor III

Re: How can I prevent line reducing in a table?

Hey..my bad...I missed to notice it is Qlik Sense...sorry again!

Not applicable

Re: How can I prevent line reducing in a table?

No, not yet. But this could be a possibilty...

prabhuappu
Contributor II

Re: How can I prevent line reducing in a table?

Hi,

You Can use Dual function to achieve this. Use the below script,

Load Dual(SmsDelivery, callid) as New_SmsDelivery,

*;

LOAD

    tcsmssuccess,

    callid,

    "time",

    SmsDelivery

FROM [lib://desktop/sms_small.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Instead of SmsDelivery Dimension use New_SmsDelivery Dimension.

Dual field stores both number and text representation in a single field.  So, even if the text representation is same Qlikview will identify it as different records because of the different  numeric value.

Please find the sample application for reference.

Capture3.PNG

Regards,

Prabhu Appu


Dual SmsDelivery

Not applicable

Re: How can I prevent line reducing in a table?

Thank you for the suggestion.

On the first view it looks like on the 2nd I've found out, that the filter won't show one the "10.00".

I think this is the price to show the lines separat, or is ther e a possiblity to reduce the value list to have only once "10.00"?

table3.PNG