Chart Calculation issue in Qlik Sense

[sibin_jacob]

Hi All,

I have used Qlik Sense Chart property Add on -> Data Handling-> Calculation Condtion

GetSelectedCount(EFF_DATE)=1

then added the message also.

I need to calculate the chart only when one EFF_DATE is selected, it is showing the message properly.

But the chart is calculating if EFF_DATE is not selected also.

so It is taking too much time to show the message, sometimes calculation time out also coming.

How we can solve this issue?

Thanks,

Sibin Jacob. C

[stantrolav]

Use this:

not IsNull(GetFieldSelections(EFF_DATE))

[sibin_jacob]

I tried this in the Add on -> Data Handling-> Calculation Condtion

It is not working.

The chart is still showing the loading image and taking too much time to show the message,

Thanks,

Sibin Jacob. C

[stantrolav]

If you want to calculate only for 1 value of EFF_DATE try this:

• Count(Distinct EFF_DATE) = 1.

My previous message was for calculation "if something in EFF_DATE is selected".

[OmarBenSalem]

count(distinct EFF_DATE)=1

[sibin_jacob]

I want to calculate the chart only when one value is selected

other wise I need to give a message "Please select a Eff Date"

I don't want to calculate the chart expression if Eff Date is not selected.

It is taking too much time to show the message in the chart.

[OmarBenSalem]

as said : count(distinct EFF_DATE)=1

Example:

One year is selected :

> 1 year selected :

[sibin_jacob]

Hi Omar,

I added the same expression in the Add on property.

Still the chart is taking time to show the message, sometimes it is showing "Calculation Timeout"

Please see the attached screenshots.

If I select one Eff_Date, the chart is showing the values correctly, without any problem.

Thanks,

Sibin Jacob. C

[stantrolav]

Ok. Try this one:

SubStringCount(GetCurrentSelections(), 'EFF_DATE: ') =1

[sibin_jacob]

I tried this one also, Still the chart is taking time to show the message and it is getting Calculation time out.

Thanks,

Sibin Jacob. C