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
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.
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...
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.
You Can use Dual function to achieve this. Use the below script,
Load Dual(SmsDelivery, callid) as New_SmsDelivery,
(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.
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"?