topic Re: Qlik sense - treemap problem with calculation condition in App Development

Qlik sense - treemap problem with calculation condition

agigliotti — Mon, 01 Oct 2018 08:37:03 GMT

Hello,

I'm facing a problem with calculation condition in data handling of treemap object.

What's happening is that treemap obejct is being calculated even if the calculation condition returns false.

In the same sheet I have a pivot table with the same expression as calculation condition and it works as expected, that is until the condition is not true the message (saying what it needed to be selected) is displayed.

As result the end user have to wait about 40 seconds, seeing the attached image, until the message I said before is being displayed.

Even worse this happening for every field selection.

Did someone face the same behavior ?

I'm using Qlik Sense Server June '18 Patch 1 version.

Thanks in advance for your time.

Best Regards

Andrea

Re: Qlik sense - treemap problem with calculation condition

timpoismans — Mon, 01 Oct 2018 09:00:30 GMT

What is your calculation discussion?

Is this based on the calculation itself?

Re: Qlik sense - treemap problem with calculation condition

agigliotti — Mon, 01 Oct 2018 09:23:49 GMT

the calculation condition i'm using is someting as below:

GetSelectedCount(field1) = 1 and GetSelectedCount(field2) = 1, and so on...

it's very very simple.

Re: Qlik sense - treemap problem with calculation condition

timpoismans — Mon, 01 Oct 2018 09:46:13 GMT

I had a similar problem in one of my views for a customer.

With the latest edition of Qlik Sense Desktop (and Server, I take), September 2018, you can now hide columns on a condition.

E.g.:

If(GetSelectedCount(NACPRDNR)=0,0,1)

I used this condition in every column that has a "complicated" measure.

So this way, only the columns that I decided would load when getting to the view and to get the rest, thus the ones that take quite a bit to load, you would need to select at least one value of [NACPRDNR].

Hope this helps.

Regards,

Tim P.