Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

How do you define varName? Can you share the expression that drives varName?

reddy-s
Master II
Master II

Hi Walter,

Use somehting like this:

sum({< country = >}Sales)

Thanks,

Sangram.

Anonymous
Not applicable
Author

In a script

SET varName = 1

I use the extension qsVariable Qlik Branch

regards,

Fritz

sunny_talwar

May be give this a shot:

Aggr(Only({<country = >} $(=Pick(Match($(varName),1,2),'products','categories'))), $(=Pick(Match($(varName),1,2),'products','categories')))

swuehl
MVP
MVP

Can you explain which part of your chart is influenced by selection in country?

As far as I see, the dimension

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

is a synthetic Dimension not linked to your data model at all.

What are your expressions? You said, you are not using sum(), count() or anything like this, but you should:

Use Aggregation Functions!

I assume you are just using a FieldName as expression, which is equivalent to

=Only(FieldName)

If so, add the set analysis to the Only() function, or any other appropriate Aggregation

=Only({<Country= >} FieldName)

edit: Ah, Should have read the complete thread

products and countries are field names, right?