Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Modifier without aggregation

Hi,

which syntax must i use, if i want to use a dimension and want to ignore the selection in field country?

Like that, but this syntax is not correct:

({<country= >} products)


regards,

Fritz

14 Replies
MVP
MVP

Re: Modifier without aggregation

May be this:

Sum({<country = >} YourField)

MVP
MVP

Re: Modifier without aggregation

Oh I think you can use product as your dimension and use set analysis in your expression to ignore country.

Highlighted
homersimpson
Contributor II

Re: Modifier without aggregation

Hi,

without sum, count or anything like this.

regards,

Fritz

MVP
MVP

Re: Modifier without aggregation

Is this for dimension

homersimpson
Contributor II

Re: Modifier without aggregation

yes

MVP
MVP

Re: Modifier without aggregation

Try this if you insist on using a dimension:

Aggr(Only({<country = >} products), products)

homersimpson
Contributor II

Re: Modifier without aggregation

Thanks...

And here?

$(=Pick(Match($(varName),1,2),'products','categories'))

regards,

Fritz

Not applicable

Re: Modifier without aggregation

You can't use the SET analysis with out aggregation function. Use the AGGR function in the calculated dimension to use SET Analysis.

AGGR( Only({<Country=>}Products) , Products)

The other way, you can use Alternate States as well based on your requirements.

MVP
MVP

Re: Modifier without aggregation

Hi,

It is not suggested to use Calculated dimensions because of performance issues, you can ignore the selections in expression, based on the expression the dimension values are populated.

Dimension: Product

Expression: Sum({<Product=>} SomeMeasureName)

If you have multiple expressions then use this in all the expressions {<Product=>}

Hope this helps you.

Regards,

Jagan.