Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Hi,

I have two bar charts with same dimenssion but different Expression and i am showing (largest 10 values with others) in my first chart, now what I want to display in my second chart is: I should get only those 10 bars which are present in my first chart and that to in the same order.

Thanks in Advance

Regards

Sagar Gupta

10 Replies
Anonymous
Not applicable
Author

Hi Sagar,

could you post an example?

Thanks

iSam

martinpohl
Partner - Master
Partner - Master

create a dynamic dimension with

if(aggr(rank( your formula from chart 1)<=10,dimension from chart 1)

and suspress others

Not applicable
Author

Hi Martin,

Many thanks for your reply,

But this is not working.....  As you mentioned i tried giving the same expression which is as below:

if(aggr(rank( Sum(if(Channel <>'Total' and (Product ='X' or Product='Y'),(Jan_Act+Feb_Act)))/1000000)<=10,Z)

Where Z= Drill down, so m not clear how to mention drill down in expression

After using this expression i am getting my first bar in both the charts same, but rest 9 bars are different.

Kindly provide me with the solution.

Regards

Sagar Gupta

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

Use this expression. i think it will be useful

if(aggr(rank( Sum(if(Channel <>'Total' and (Product ='X' or Product='Y'),(Jan_Act+Feb_Act)))/1000000)<=10,Getcurrentfield(DrillDownGroupname)))

Not applicable
Author

Nahhhh,

Not working dude.

😞

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

if possible uplod ur sample file ,

Not applicable
Author

Hey if you don't mind, is it possible for you to come online on Skype

Regards

Sagar Gupta

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

My Skypeid Perumal_41

Not applicable
Author

Mine sagargupta43