3 Replies Latest reply: Feb 3, 2016 8:06 AM by Anton Aleksandrov RSS

    show 1:M data in qlikview straight table

    vir vir

      Hi,

       

      I have to show my data as given below:

       

      ID          Booking                   Villa Number

      1           BO!                               V01

      2           B02                               v03

       

       

      i have to show this data in straight table but the issue is that .......

       

      for example ID 1 have booked 2 villa but we can only show 1 villa number in the field.

       

      in my case data is coming as blank........................i have some other record where 1 ID have booked more than 5 VIlla ...kindly suggest .

      AND WE DONT WANT DUPLICATE DATA

      but my major goal is to pick idS BUT vILLA NUMBER SHOULD NOT BE NULL ...