how to check

[kunkumnaveen]

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

[Anil_Babu_Samineni]

It will works default

Please disable this from presentation Tab

[Anonymous]

Hi,

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

Thanks

Paridhi

[kunkumnaveen]

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)