Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qliklearnervir
New Contributor III

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
Esteemed Contributor III

Re: Want to show dedup scenerio or flag

=distinct(Email)

qliklearnervir
New Contributor III

Re: Want to show dedup scenerio or flag

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....

Re: Want to show dedup scenerio or flag

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

agni_gold
Valued Contributor II

Re: Want to show dedup scenerio or flag

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 .

vsudhakar
Contributor III

Re: Want to show dedup scenerio or flag

distinct (email)

qliklearnervir
New Contributor III

Re: Want to show dedup scenerio or flag

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
Honored Contributor III

Re: Want to show dedup scenerio or flag

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

Capture.JPG

qliklearnervir
New Contributor III

Re: Want to show dedup scenerio or flag

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
New Contributor III

Re: Want to show dedup scenerio or flag

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.

Community Browser