How to pass a hardcoded filter into a straight table in qlikview

[Anonymous]

Hi Experts,

i have the below requirement as given below,

Filter : Country

Values : India , China , Russia

I want to display individual straight tables for each country's details.

the report will not be provided with the "Country" filter as a list box ..

i want to pass the hardcoded value into each table which will be specific for each country.

Kinldy help me on this .

Thanks

[Anil_Babu_Samineni]

You may try this definition for each chart

Sum({<Country = {'India'} >} Measure)

Sum({<Country = {'China'} >} Measure)

Sum({<Country = {'Russia'} >} Measure)

[Anonymous]

Hi Anil , can we do it while adding dimensions ?

[Anonymous]

=IF(Aggr(Rank(Count(Distinct(SalesPersonId)),2),SalesPersonName)<=10 ,Country)

i am using the above expression to calculate the top 10 rank , in calculated dimension

now how can i pass specific country into this ??

[Anil_Babu_Samineni]

This functions will effect to the dimension as well when you use same in measure, Anyway

If(Country='India', Country)

If(Country='China', Country)

If(Country='Russia', Country)

[Anil_Babu_Samineni · Accepted solution]

You can use like this?

=IF(Aggr(Rank(Count({<Country = {'India'}>} Distinct SalesPersonId)),2),SalesPersonName)<=10 ,Country)

[Anonymous]

Thanks Raju , This is working absolutely fine