Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

srikantj
Contributor

how to add filtered dimension

i have straight table fileds country ,type, id, order with blank expression

when i add country dimension i dont want to add whole country .. i want to add only country-->india

not all contries

how can i add filtered dimension

Qlllikkkks ... Suggest

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: how to add filtered dimension

Seems like that op have blank expression.... May be this

Avg({<Country = {'India'}>} 1)

and then hide the expression from the Presentation tab?

5 Replies

Re: how to add filtered dimension

Use set analysis in your expression

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

MVP
MVP

Re: how to add filtered dimension

May be like this

If(Country = 'India', Country)

surendraj
Valued Contributor

Re: how to add filtered dimension

Use the set expression in Stright table

Count(<{ country={'india'}>}id)

MVP
MVP

Re: how to add filtered dimension

Seems like that op have blank expression.... May be this

Avg({<Country = {'India'}>} 1)

and then hide the expression from the Presentation tab?

sravanthialuval
Contributor

Re: how to add filtered dimension

Create one calculated dimension for County using below expression

if(Country='india',Country)  and enable suppress when value is null option.