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: 
kunkumnaveen
Specialist
Specialist

how to check

HI how can i get this requirement ,i need to show products of a   customer who buy more then once when a particular year is selected

it has to check name and mobile because name might be repeated but mobile num is unique 

Product   Name       Year                 Mobile

xxx           joe            2015                 0000

xxx             joe            2015              9999

yyy            joe             2015               0000

yyy            roy            2016                 1111

result i need when 2015 is selected i am thinking to show in a straight table

product      year         name

xxx             2015          joe

yyy              2015         joe

thanks

4 Replies
Anil_Babu_Samineni

It will works default

Capture.PNG

Please disable this from presentation Tab

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

Hi,

It works by default because qlikview have associative property,whenever you selected it will show associate data.

Thanks

Paridhi

kunkumnaveen
Specialist
Specialist
Author

how to write this in qlikview

if((Name&Mobile)=(Name&Mobile) then Product

Anil_Babu_Samineni

Create Script level

Load *, Name & Mobile as Key;

Load Name, Mobile from Source;

Then expression is this If(Key = Key, Product)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)