Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

stright table

Hi All,

Olivier GAUTIER

i want to top 10 customers in stright table  [not through dimension limit tab]

thanks

sony

1 Solution

Accepted Solutions
Highlighted

Try this?

Measure1:

Sum({<[Type]={'Hw'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure2:

Sum({<[Type]={'Sr'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure3:

Sum({<[ Name]=$::[ Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

5 Replies
Highlighted
Partner
Partner

Hi Sony,

1. what are you asking? I cannot understand...

2. ok, but why you don't want to use the dimension limit?

Simone

Highlighted
Specialist III
Specialist III

i want to dispaly top 10 customers in the table

if i use dimension limit tab it is not giving exact  10 bcz i  have 3measures

i think that is the reason

so how can i achieve this?

Highlighted

Try this?

Measure1:

Sum({<[Type]={'Hw'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure2:

Sum({<[Type]={'Sr'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure3:

Sum({<[ Name]=$::[ Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Specialist II
Specialist II

Hi,

Sony,

do you want top 10 total sales and then the 3 measures (if so Anil's solution)

or do you want for each selection top 10 in it ?

regards

Highlighted
Specialist III
Specialist III

thanks sir it worked.