topic Re: pivot table duplicate value not showing and other column's data also not showing in QlikView

pivot table duplicate value not showing and other column's data also not showing

shivam0703 — Mon, 26 Jan 2026 18:19:17 GMT

Here in the image attached u can see PIN data(two values) is available in table box but in thw pivot or straight table all values are blank also in table box there is multiples values too in lead ID but in straight table that too not showing how to overcome from such issue?

I need all the data in pivot table just (leadid) field is selected in dimention and pin in measure not other function then what is the issue can anyone tell??

Re: pivot table duplicate value not showing and other column's data also not showing

Or — Mon, 15 Mar 2021 14:08:26 GMT

It looks like PIN is set to be a measure. There are multiple PINs, so Qlik doesn't know what to display. You need to either make PIN a dimension, or tell Qlik what to do when there are multiple PINs, e.g. use a function such as Count(PIN), Concat(PIN), etc.

Re: pivot table duplicate value not showing and other column's data also not showing

shivam0703 — Mon, 15 Mar 2021 14:28:29 GMT

PIN is already in measure but PIN is showing bank values and lead id column is not showing duplicate values too.

Re: pivot table duplicate value not showing and other column's data also not showing

Or — Mon, 15 Mar 2021 14:31:23 GMT

The fact that PIN is a measure *is* your problem. Make it a dimension, or tell Qlik how to handle it as a measure when there are multiple values.

Re: pivot table duplicate value not showing and other column's data also not showing

shivam0703 — Mon, 15 Mar 2021 14:34:20 GMT

If I make it measure then It will show me only 2 rows but I need all 7 rows as per the lead ID what else can be the solution to remain PIN as a measure but should display some data

Re: pivot table duplicate value not showing and other column's data also not showing

Or — Mon, 15 Mar 2021 14:37:44 GMT

There is no solution I know of to put a field in the measures, but have it behave like a dimension. I don't understand why you don't just use it as a dimension in the first place if that's what you want... perhaps someone else can help you with this.