Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
berryandcherry6
Not applicable

Choosing max 8 campaign_id for Particular batch

Hi all,

Here i am having two columns,one is campaign_id and batch_meta_data_id.I want to get max 8 id's for particular batch id.

How could i acheive this please help me.

Tags (2)
5 Replies
sunny_talwar
Not applicable

Re: Choosing max 8 campaign_id for Particular batch

Where are you wanting to do this? In the script or front end? Can you elaborate a little?

berryandcherry6
Not applicable

Re: Choosing max 8 campaign_id for Particular batch

In front end.

I am trying to do this because i want to find current campaign and previous campaign for a particular client.Each client will be having batches.So for each batch i am choosing max of campaign_id in expression.

kush141087
Not applicable

Re: Choosing max 8 campaign_id for Particular batch

On what basis you want to find the 8 max Id's?

berryandcherry6
Not applicable

Re: Choosing max 8 campaign_id for Particular batch

For every particular batch id ,i want to find 1st max value,2nd max value,3rd max value .....,8th max value of campaign id.

ex if there is batch_id = 34,35

campaign_id  batch_id

     1                34

      2               34

     3                34

     4                35

      5                36

      6                 36

      7                 36

       8                36

       9               34

      10                35

      11                 35

       12                35

        13               35

         14               35

here i want to get campaign_id as 12,13,14 for batch_id 35,campaign_id as 9,3,2 for batch_id 34 if i am choosing max 3 values in campaign_id column.

berryandcherry6
Not applicable

Re: Choosing max 8 campaign_id for Particular batch

Hi,

Thanks for reply

However,in load script or front end ,i want to get datas.

I am trying to do this because i want to find current campaign and previous campaign for a particular client.Each client will be having batches.So for each batch i am choosing max of campaign_id in expression.

Please help me in this regard