modify Inline table rows based on value

[berryandcherry6]

Hi,

i have a inline table as below

Metrics:

LOAD * INLINE [

   client_id, Metrics,Metrics-SortOrder

    1, INVITATIONS,1

    1, DELIVERED,2

    1, OPEN,3

    1, BOUNCE,4

    1,CTR,5

    1, SIGN-UP,6

    2, INVITATIONS,1

    2, DELIVERED,2

    2,OPEN,3

    3, DELIVERED,2

    3, OPEN,3

    3, BOUNCE,4

    3,CTR,5

    4, INVITATIONS,1

    4, DELIVERED,2

    4,OPEN,3

];

In above inline table you can see that

1.) Different Client_id has different row

2.) some have like client_id 2 and 5, they have same rows

But above is tedious, if client gets increase number of rows in table get increases and not a right way, i have to make it dynamic or something shorter to achieve same result.

Can i put logical and/or for client_id having same rows?

Any idea in this? or other work around i could achieve. Any suggestions.

[vinieme12]

Hi berryandcherry64

If your query is resolved can you mark a response as correct and close the thread please

Qlik Community Tip: Marking Replies as Correct or Helpful

[berryandcherry6]

Hi Rahul,

Thanks It really was a good idea, but like Vineeth as shown it should be a crosstable.

[rahulpawarb]

Yes Supriya, I agree with you & Vineeth.

Thank you Vineeth.