How can I prevent line reducing in a table?

[#1]

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

[m_woolf]

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.

[Anonymous]

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

[#4]

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...

[#5]

How can I hide a table column in Qlik sense?

[m_woolf]

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.

[Anonymous]

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

[#8]

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

[prabhuappu]

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.

Regards,

Prabhu Appu

Dual SmsDelivery

[#10]

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"?