topic Re: How to pass a hardcoded filter into a straight table in qlikview in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 09 May 2018 14:04:29 GMT

You may try this definition for each chart

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

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

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

Anonymous — Wed, 09 May 2018 14:14:01 GMT

Hi Anil , can we do it while adding dimensions ?

Anonymous — Wed, 09 May 2018 14:16:07 GMT

=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 — Wed, 09 May 2018 14:17:05 GMT

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 — Wed, 09 May 2018 14:18:28 GMT

You can use like this?

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

Anonymous — Wed, 09 May 2018 15:20:42 GMT

Thanks Raju , This is working absolutely fine