topic Re: how to check in QlikView

how to check

kunkumnaveen — Thu, 13 Apr 2017 05:44:21 GMT

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 — Thu, 13 Apr 2017 05:49:03 GMT

It will works default

Please disable this from presentation Tab

Anonymous — Thu, 13 Apr 2017 05:53:22 GMT

Hi,

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

Thanks

Paridhi

kunkumnaveen — Thu, 13 Apr 2017 05:53:50 GMT

how to write this in qlikview

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

Anil_Babu_Samineni — Thu, 13 Apr 2017 05:56:23 GMT

Create Script level

Load *, Name & Mobile as Key;

Load Name, Mobile from Source;

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