topic logic help in QlikView

logic help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have scenario in which i have data like below

Field1 Value

asd-11 10

qwe-12 11

edc-43 12

Repeat 8

asd-11 11

qwe-12 12

qwe-13 11

You can see in this, asd-11 having two rows , by default if we put this in bar chart it will agrregate, so to overcome this and show it differently i used

dual( Field1, RowNo()) as Field1 and its working but issue is in this you can see one row is value Repeat, i m loosing that row

please suggest how i can get it?

Re: logic help

Saravanan_Desingh — Sat, 12 Mar 2016 05:22:48 GMT

I'm not sure, if I understand.

I tried the same and I didn't get missing anything. Please check the attachment.

Re: logic help

amayuresh — Mon, 14 Mar 2016 07:03:18 GMT

It is working fine for me

I used below script:

t1:

LOAD * INLINE [

Field1, Value

asd-11, 10

qwe-12, 11

edc-43, 12

Repeat, 8

asd-11, 11

qwe-12, 12

qwe-13, 11

];

NoConcatenate

t2:

Load dual( Field1, RowNo()) as Field1,Value Resident t1;

Drop Table t1;

Bar chart with Dimention Field1 and expression as sum(Value)