topic Re: question on displaying duplicate dimension values in QlikView

question on displaying duplicate dimension values

gerrycastellino — Fri, 11 Dec 2015 18:00:49 GMT

I have a dimension [Ticket Number] which has 2 recoreds of 'INC0786067' - these are associated with 2 values in the metric field of

351/350.

I have created a simple straight table with Dimension as [Ticket Number] and Metric as OpenTicket_Length.

I'm not seeing the duplicate dimension values as I would like to see - same with the metric.

Re: question on displaying duplicate dimension values

maxgro — Fri, 11 Dec 2015 18:07:44 GMT

you see the distinct dimension

A solution could be: add a counter in the script (ie rowno()), add this new field in the chart as dimension and hide this field in presentation tab (this works for straight table)

Re: question on displaying duplicate dimension values

Fri, 11 Dec 2015 18:08:16 GMT

what have you done on the first table compare to the second one? Is one a table box and the other a striaght table?

Re: question on displaying duplicate dimension values

Fri, 11 Dec 2015 18:08:45 GMT

does it ahve to be a straight table? what about a pivot table?

Re: question on displaying duplicate dimension values

gerrycastellino — Fri, 11 Dec 2015 18:12:33 GMT

I could do pivot table, seems to be the same results though.

Re: question on displaying duplicate dimension values

Fri, 11 Dec 2015 18:16:05 GMT

ws?can you provide a qvw

if you have an expression as =openticketlength and the ticket as the dimension it should work

Re: question on displaying duplicate dimension values

MarcoWedel — Sat, 12 Dec 2015 02:39:52 GMT

‌OpenTicket_Length seems to be field as well, so try a table box instead of a straight table or make it a dimension rather than an expression in the straight table (possibly without expression and unselected suppress null values option).

regards

Marco