topic removing duplicate values from pivot table in QlikView

removing duplicate values from pivot table

vijetas42 — Mon, 30 Oct 2017 10:36:08 GMT

Hi All,

I have below scenario in which i need to values should show in my pivot table only once if it gets repeated with respect to vendor.Please suggest.

Project	Vendor	docno.	Value	expected output
A121	V1	d1010	134	134
	V1	d1020	134	0
	V2	e1010	137	137
	V3	e1011	136	136
	V3	d1022	136	0
	V3	d1023	132	132

Thanks!

Re: removing duplicate values from pivot table

devarasu07 — Mon, 30 Oct 2017 10:45:08 GMT

Hi,

Based on you data, when we use pivot chart object by default it should give you the desired output. what is the issue. can you elabrate more (i.e share like source data, current & expected output) tks

Re: removing duplicate values from pivot table

avinashelite — Mon, 30 Oct 2017 10:45:40 GMT

What is the logic your using to determine the value ? how your basing the uniqueness , on which columns

Re: removing duplicate values from pivot table

vijetas42 — Mon, 30 Oct 2017 10:49:07 GMT

uniqueness of value should be based on column vendor

Re: removing duplicate values from pivot table

vijetas42 — Mon, 30 Oct 2017 10:50:18 GMT

Please see the screenshot where I have mentioned the expected output should be like for duplicate it should consider 0

Re: removing duplicate values from pivot table

devarasu07 — Mon, 30 Oct 2017 10:58:25 GMT

How you derive the Value measure? in your screen shot DocNo is unique field and if we apply your suggested rule then the last row (V3 d1023 132 as expected output?

Re: removing duplicate values from pivot table

avinashelite — Mon, 30 Oct 2017 11:18:39 GMT

If its on the vendor ..then you have mentioned 2 values for V3, which is wrong rite ? could you re-check again give us the logic

Re: removing duplicate values from pivot table

parthesh — Mon, 30 Oct 2017 14:07:31 GMT

I think in script you have to handle this..

Please find below demo for this... hope this will help..

Temp:

LOAD * Inline [

Name,Value

V1,10

V1,20

V1,30

V2,1000

V2,20

V2,30

V3,10232

V3,20

V3,30

];

Temp2:

Load

Name,

Value,

if(Name = Previous(Name),0,Value) as NewValue

Resident Temp ;

Drop Table Temp;