topic Re: Duplicate row Issue in QlikView

Duplicate row Issue

tamilarasu — Tue, 03 Feb 2015 04:47:29 GMT

Hi,

I have a two rows and all the field values are same except one field value. I have added the fields in chart and try to display both the rows but Qlikview is showing one row (values are same) and the specific field value is displaying as hyphen. I can't upload the file here because of the size and I need to edit only via expressions (Data model already exists and I am getting the results by linking few tables). Any idea about this?

Re: Duplicate row Issue

jonathandienst — Tue, 03 Feb 2015 06:16:41 GMT

Make that field a dimension rather than an expression.

HTH

Jonathan

Re: Duplicate row Issue

tamilarasu — Wed, 04 Feb 2015 04:26:04 GMT

Thanks Jonathan..

It works but I am facing another problem in the resultant chart. Now, I have the following data.

I need the following result.

Can you suggest me a expression for this.

Regards,

Tamil

Re: Duplicate row Issue

Anonymous — Wed, 04 Feb 2015 05:03:38 GMT

Hi,

Modifying data doesn't make any sense in QlikView as you have two different conditions for same R.No.

Pls make sure the source data is correct

Thanks,

Vignesh

Re: Duplicate row Issue

tamilarasu — Wed, 04 Feb 2015 05:07:59 GMT

Sorry it was my mistake. It was just a sample data so the row number can be 3.

Thank you.

Re: Duplicate row Issue

Anonymous — Wed, 04 Feb 2015 05:14:35 GMT

So how do you need the output in this case??

The same like above is not possible

Re: Duplicate row Issue

robert_mika — Wed, 04 Feb 2015 05:15:51 GMT

Could you post few more example and desired result (draw a sketch or show jpg from Qlikview)

Re: Duplicate row Issue

tamilarasu — Wed, 04 Feb 2015 05:18:25 GMT

Here the row number is just for the understanding. I need output like below.

I need is to take the PSP value and show it in add value field, since the product is same.

Re: Duplicate row Issue

jonathandienst — Wed, 04 Feb 2015 05:23:47 GMT

Take Condition out of the list of dimensions and add an expression that displays the correct value from Condition (ie whatever rule you use to pick Fix over PSP...), or add both using Concat(Condition, ', ')

HTH

Jonathan

Re: Duplicate row Issue

tamilarasu — Wed, 04 Feb 2015 05:24:20 GMT

Thank you Robert for your response,

If I have ZPSP value for the particular product then I need to show the value in Add Value column for all conditions (Fix and DIL).

Re: Duplicate row Issue

robert_mika — Wed, 04 Feb 2015 08:38:36 GMT

t1:

LOAD R.No,

Name,

Condition,

Prod,

Value,

[Add Value]

FROM

Samp.xlsx

(ooxml, embedded labels, table is Sheet1);

t2:

mapping load Prod as PR,[Add Value] as t2v

Resident t1

where Value='-';

t3:

load R.No as R.Nom,Name as Nam,Condition as Cond,Prod as Product, Value as Val ,applymap('t2',Prod) as [Add Value]

Resident t1

Where Value <>'-';

Drop Table t1

Re: Duplicate row Issue

tamilarasu — Thu, 05 Feb 2015 08:02:26 GMT

Thanks for your input Robert and great.

Sorry but I need to do it in expression, I can not edit data model (Big one) as it was already created. Could you help me on this.

Re: Duplicate row Issue

rubenmarin — Thu, 05 Feb 2015 08:27:52 GMT

Hi Tamil you can use as Add Value expression:

If(Condition='PSP', Null(),

only(TOTAL <Prod> {<Condition={'PSP'}>} [Add Value]))

If you have checked supress null values, the row with Condition='PSP' should dissapear and the Add Value populated in the rows of the product.

That expression assumes there is only one Add Value for each product where Condition='PSP'