topic Set Analysis - show no records when all dimensions are excluded in App Development

Set Analysis - show no records when all dimensions are excluded

northerner — Sat, 16 Nov 2024 04:22:31 GMT

I have a simple table with four products:

Products A and B are very important to my users, so they should be shown in a table on their own. There is also a filter allowing a user to select a product:

The measure in the table is calculated as: Sum({<Name*={'A', 'B'}>} Value)

This is so that the table shows records for A and B when they are selected or possible. But if a user selects a Product that is not A or B, then nothing should be shown.

This works ok when A and B are selected or possible e.g.:

But it show this when I select Product C:

In this case I want to see no rows in the table - A and B are not selected so my users don't want to see any data.

I know I could turn off 'Include zero values' in Data Handling but this is a problem if the value for A or B is 0. E.g. if the value for A is 0, it's important for my users to see this - they need to know that A has 0 value.

I feel like there is an obvious solution to this problem but I can't think what it is. Any ideas?

Re: Set Analysis - show no records when all dimensions are excluded

asinha1991 — Tue, 15 Oct 2019 18:54:44 GMT

did you try unchecking include nulls under your dimension NAME? or you can try this

if(not match(NAME,'A','B'),null(),Sum({<Name={'A', 'B'}>} Value))

Re: Set Analysis - show no records when all dimensions are excluded

northerner — Tue, 15 Oct 2019 19:02:08 GMT

Thanks for the suggestion. However I get this:

'Include null values' doesn't make a difference

Re: Set Analysis - show no records when all dimensions are excluded

asinha1991 — Tue, 15 Oct 2019 20:04:19 GMT

then try this

in dimension create

if(match(NAME,'A','B'),NAME)

remove set analysis from expression(redundant)

and uncheck include null values

Re: Set Analysis - show no records when all dimensions are excluded

northerner — Wed, 16 Oct 2019 07:10:19 GMT

Thanks for your response but unfortunately this doesn't work:

Include null values is unchecked

Re: Set Analysis - show no records when all dimensions are excluded

Mauritz_SA — Wed, 16 Oct 2019 07:58:47 GMT

Hi there

Try making Name your Dimension and make your measure this:

Sum({<Name=,Name={'A','B'}>} Value)

Regards,

Mauritz

Re: Set Analysis - show no records when all dimensions are excluded

northerner — Wed, 16 Oct 2019 08:07:58 GMT

Thanks for your suggestion. Unfortunately this doesn't work as when I select Product C in the filter box, Product A and B are displayed in the table. I need the table to be blank (with no records displayed) when the selected product is not A or B

Re: Set Analysis - show no records when all dimensions are excluded

Ksrinivasan — Wed, 16 Oct 2019 09:03:18 GMT

Hi,

section access; is the best solution to your visualization, you can control what ever you want.

and as your way it will work (Exclude selections will not displayed in selection and table)

Example:

section access;

load * inline [

ACCESS, USERID, PRODUC_ID

ADMIN, \matr, *

USER, \matr, C

USER, \report, D

];
SECTION APPLICATION;

K. Srinivasan.

Re: Set Analysis - show no records when all dimensions are excluded

StarinieriG — Wed, 16 Oct 2019 09:17:37 GMT

Hi,

try with this expression

Sum({<Name*={'A', 'B'}>} Value+0.001)

suppress 0 values and set format number, so it will show 0 and not 0.001

Re: Set Analysis - show no records when all dimensions are excluded

Ksrinivasan — Wed, 16 Oct 2019 09:48:29 GMT

@StarinieriG,

i have tried, but

it has shows 0.001 value for A, B

same old status continue for C and D same :

K. Srinvasan

Re: Set Analysis - show no records when all dimensions are excluded

StarinieriG — Wed, 16 Oct 2019 10:11:06 GMT

You have to set format number too (with max of 2 decimals), otherwise you will see 0.001

And suppress 0 values

Re: Set Analysis - show no records when all dimensions are excluded

kumar2 — Mon, 31 Jan 2022 07:39:49 GMT

Try this in Addons "Calculated Conditions" in Qliksense

if(wildmatch(GetFieldSelections(Name),'*C*','*D*'),0,1)