Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
chandana_gowdar
Creator II
Creator II

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

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

You can use like this?

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

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

6 Replies
Anil_Babu_Samineni

You may try this definition for each chart

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

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

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

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)
chandana_gowdar
Creator II
Creator II
Author

Hi Anil , can we do it while adding dimensions ?

chandana_gowdar
Creator II
Creator II
Author

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

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

You can use like this?

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

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)
chandana_gowdar
Creator II
Creator II
Author

Thanks Raju , This is working absolutely fine