topic Re: To Show Common Values Against One ID in QlikView

To Show Common Values Against One ID

Wed, 23 Oct 2013 18:01:15 GMT

Hi All,

I have the Two dimensions ID and Truck No like

ID TRUCK No

10 00010

10 00035

10 00045

10 00060

20 00010

20 00045

30 00090

40 00086

50 0090

I want to show he common values like Id 10 or 20 bothe have some common values i.e 00010 and 00045 show I want to show once against only ID 10 not show the 20 ID in the Table.

Can any one Please give me idea ??

Regards

Deepak

Re: To Show Common Values Against One ID

tresB — Wed, 23 Oct 2013 18:08:43 GMT

So is it like, you want the TRUCK No values to be shown once against the first appearance in ID? If so, may be you can try Not Exists() in the script in Where clause.

Re: To Show Common Values Against One ID

Wed, 23 Oct 2013 18:18:17 GMT

Hi Tresesco,

Thanks for reply. but I want in only one report to show the common Truck No against One ID.I can n't apply in the script.

Can I do in the front end ??

Regards

Deepak