Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

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

Hi Sagar,

could you post an example?

Thanks

iSam

Highlighted
Partner
Partner

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

create a dynamic dimension with

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

and suspress others

Highlighted
Not applicable

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

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

Highlighted
Partner
Partner

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

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)))

Highlighted
Not applicable

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

Nahhhh,

Not working dude.

😞

Highlighted
Partner
Partner

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

Hi,

if possible uplod ur sample file ,

Highlighted
Not applicable

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

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

Regards

Sagar Gupta

Highlighted
Partner
Partner

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

Hi

My Skypeid Perumal_41

Highlighted
Not applicable

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

Mine sagargupta43