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: 
qliklearnervir
Creator
Creator

Want to show dedup scenerio or flag

Hi,

We have availalbe data like this :

Booking ID      PersonID                  Email

B01                 P01                           ABC@mail.com

B02                 P02                          XYZ@mail.com

B03                 P01                           ABC@MAIL.COM

B04                 P01                          ABC@mail.com

B05                  P02                        XYZ@mail.com

Now as per scenerio , i dont to miss any data ....

like   if i want unique email than my daa should like

ABC@mail.com

XYZ@mail.com

But i want all the Booking ids....not like max of email and limited ids...

same for person id ......if i can say i   want  unique person than in straight table i want all booking ids and email.......kindly suggest

12 Replies
Chanty4u
MVP
MVP

=distinct(Email)

qliklearnervir
Creator
Creator
Author

No,,this will not help......

My scenario is different from your suggestion.

As per my scenario i want the  combinations like:

Booking ID ---> Person ID

PersonID--> Email

EMail---> Person ID

Email---> Booking ID

For example one person having 2 email address for same personID.

one person having multiple booking from same email and personID

.....Please suggest....

sunny_talwar

Not entirely sure I understand your question. Do you mind re-explaining your question again please?

agni_gold
Specialist III
Specialist III

I think , if you use Pivot table instead of Straight table , then you may get your result ,

I haven't tried , but may be possible .

Anonymous
Not applicable

distinct (email)

qliklearnervir
Creator
Creator
Author

Pivot is fine ....but i have to use Nprinting extract nd want to share the file as CSV..........

Instead of Pivot i want table like:

3 scenario:

On behalf of Booking ID

On Behalf of Person ID

On Behalf of  Email...............

May be Flag or any other mechanism we can use to separate the data............

Digvijay_Singh

Do you want like this - used =Concat([Booking ID],',') kinda expression

Capture.JPG

qliklearnervir
Creator
Creator
Author

yes you are correct.....but one more addition is required like ...............

i want to do this from flag or button like.................

distinct email and booking ids

distinct booking ids and email

distinct person id and email

distinct email and person ids........

qliklearnervir
Creator
Creator
Author

One more thing is there any way , we can define the occurrence of the field Like.

Booking ID    Email                  occurrance

1                  ABC.mail.com      1

2                 ABC.mail.com        2

3                 xyz.mail.com           1

4                aaa@mil.com           1

but occurrence should be in qlikview script.