Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display extra record?

Hi All,

I have a field with unique, but it has more than one record, there i need to display how many more than one  records or there for that field.

17 Replies
swuehl
MVP
MVP

It would be most easy to create a duplicate flag in the load script:

LOAD *,

if(exists(id),1,0) as Flag

INLINE [

id,    value

101,  axe

101,  box

101,   car

102,   pen

103,  axe

102,   car  

];

Then create a list box with Flag field and a table box with fields id and value. Select 1 in Flag list box. Done.

Not applicable
Author

Hi Parthiban

Thank you for replay, just go through this

        id    value

       101  axe

       101  box

       101   car

       102   pen

        103  axe

       102   car  

Here 101 has 2 more records same time 102 has 1 record more so i want to display the count of more record in this case it is    2

                 1

and i want those two records .

out put:  i am expecting:       id   value

                                          101  box

                                          101  car

                                           102 car

Hope its clear to you..

swuehl
MVP
MVP

In addition to my above post, if you want to show the number of duplicates, just create a straight table chart with dimension id and as expression

=sum(Flag)

Not applicable
Author

Hi Massimo Grossi

Thank you for replay, just go through this

        id    value

       101  axe

       101  box

       101   car

       102   pen

        103  axe

       102   car 

Here 101 has 2 more records same time 102 has 1 record more so i want to display the count of more record in this case it is    2

                 1

and i want those two records .

out put:  i am expecting:       id   value

                                          101  box

                                          101  car

                                           102 car

Hope its clear to you..

Thank You

Not applicable
Author

swuehl thank you for the replay

it shows only the count but i need those records .

swuehl
MVP
MVP

It will show the records if you follow my previous post.

You can also create a straight table with dimensions id and value and expression

=sum(Flag)

Then hide the expression in presentation tab.

Not applicable
Author

Thank you so much...SWUEHL

Not applicable
Author

This is my data and i need the difference value records from each table according to position

Table1:

CustomerContractpositionpartcompany
1212101working12Bmw
1215101repaired13skoda
1254102unused12Audy
1254103working13Bmw
1212105repaired41skoda
1215106unused42Audy
1211107working12Bmw


Table2:

CustomerContractpositionpartcompanydate
1212101working12Bmw1/12/2011
1215101repaired13skoda2/12/2012
1254102unused12Audy4/11/2010
1254103working13Bmw3/6/2010
1212105repaired41skoda6/4/2009
1215106unused42Audy5/4/2008
1211107working12Bmw4/9/2012
1211108working12Bmw02/5/1/2013
12102107working43Audy11/3/1911
1205109repaired44bmw12/7/2011
1205107unused46skoda11/3/1911
1208109working47bmw11/4/1202


Here have struck what I have upto know


  Position:     Total contract in table1               Total contract in table2        difference

  working              3                                                  6                                 3



here difference is 3 , now i need those 3 different records from table 2.


Hope you understand Please Provide me some help to over come this.   Thank you.