topic Text and image object with calculation condition in App Development

Text and image object with calculation condition

NicolaiF — Sat, 16 Nov 2024 19:50:46 GMT

Hi Qlik Community,

I am struggling with a calculation which is fairly heavy causing my whole report to run slowly.
However, the calculation is only relevant if the user has made some selections.
I would therefore like to add a calculation condition so that the calculation is only evaluated if the user has made selections.

It seems like I am only able to use calculation conditions in KPI's. However, it is required that I use text and image objects in the report...

Does anyone know a way to implement calculation conditions on a text and image object or alternatively apply a calculation condition directly on the measure?

Cheers

Re: Text and image object with calculation condition

vunguyenq89 — Tue, 22 Oct 2019 09:51:40 GMT

How about using an IF condition with GetSelectedCount() function to check whether there are any current user selections on particular fields? For example

=If(GetSelectedCount(City) = 0, 'Please select at least one city', Sum(Sales))

BR,

Vu Nguyen

Re: Text and image object with calculation condition

NicolaiF — Tue, 22 Oct 2019 10:06:57 GMT

That was my initial though as well. However, I found out that Qlik sense evaluates all inputs in an IF-statement no matter what condition is fulfilled in the statement.

Example in the expression below both "Expression1" and "Expression2" will be evaluated no matter the size of "A".
It evaluates all inputs and returns the correct one.

IF(A>1,
[Expression1],
[Expression2])

Re: Text and image object with calculation condition

vunguyenq89 — Tue, 22 Oct 2019 10:19:18 GMT

It's strange. The IF condition works in my example below

Can you share the expression and maybe some sample data?

Re: Text and image object with calculation condition

naumanshah — Tue, 22 Oct 2019 10:20:58 GMT

You may also explore Custom Objects > Show/hide container

Re: Text and image object with calculation condition

NicolaiF — Tue, 22 Oct 2019 10:31:38 GMT

The expression works, yes.

But Qlik will evaluate both expressions - As in it will use CPU's and calculation time to calculate both expressions.
It will return the right result yes, but even if you do something like:

IF(GetSelectedCount(Field1)<2, 0, [Heavy expression])

your measure will still run slow because it evaluates the 'heavy expression' before returning the value '0'...
It is just qlik functionality..

Re: Text and image object with calculation condition

NicolaiF — Tue, 22 Oct 2019 11:38:07 GMT

Does the Hide/show container evaluate all the visualisations when it is used?

Or does it first evaulate when the "Show condition for chart" is fulfilled?

Re: Text and image object with calculation condition

naumanshah — Tue, 22 Oct 2019 14:08:44 GMT

It will just evaluate "Show condition for chart" and if it is true, it will show that particular visualization.

You may add it like: