Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

larisa_filonova
Contributor III

question about set analysis

Hi,

I am using the set analysis to implement my task and I have found out some unlogical features.

My task is as follows: on the one hand a user must be able to select the needed brands in a list box and make some analysis based on these brands, on the other hand a user must always see TOP-10 brands on the screen regardless of his/her choice in the list box.

I decided that set analysis is the best tool to solve the task. In order to calculate top 10 brands I use the expression:

if (Rank(Sum( {$<Brands>} [Budget] ))<=10, Sum({$<Brands>} [Budget] ),0) .

Then I activate the option 'supress when value is null'.

But the brands with null value are not being supressed. So, I can't show TOP-10 brands only.

Please see the file attached.

Could you please help to find out how I can supress nulls?

Larisa Filonova

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: question about set analysis

See attached example.


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: question about set analysis

The fields in the document you posted do not contain null values.

Instead of your if statement you can also use Dimension Limits or a set analysis expression like Sum({$<Brands={"=rank(sum({<Brands=>}Budget))<11"}>} [Budget] )


talk is cheap, supply exceeds demand
larisa_filonova
Contributor III

Re: question about set analysis

I prefer a set expression to Dimension Limits. But if I change my if statement to the suggested expression: Sum({$<Brands={"=rank(sum({<Brands=>}Budget)<11)"}>} [Budget] ) then TOP-10 brands are not distinguished, and the budget of all other brands is calculated too. Please see the file attached.

MVP & Luminary
MVP & Luminary

Re: question about set analysis

See attached example.


talk is cheap, supply exceeds demand
Community Browser