Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sibin_jacob
Contributor III

Chart Calculation issue in Qlik Sense

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

11 Replies
stantrolav
Contributor II

Re: Chart Calculation issue in Qlik Sense

Use this:

not IsNull(GetFieldSelections(EFF_DATE))

sibin_jacob
Contributor III

Re: Chart Calculation issue in Qlik Sense

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
Contributor II

Re: Chart Calculation issue in Qlik Sense

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
Esteemed Contributor

Re: Chart Calculation issue in Qlik Sense

count(distinct EFF_DATE)=1

sibin_jacob
Contributor III

Re: Chart Calculation issue in Qlik Sense

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
Esteemed Contributor

Re: Chart Calculation issue in Qlik Sense

as said : count(distinct EFF_DATE)=1

Example:

Capture.PNG

One year is selected :

Capture.PNG

> 1 year selected :

Capture.PNG

sibin_jacob
Contributor III

Re: Chart Calculation issue in Qlik Sense

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.

image3.png

image2.png

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

Thanks,

Sibin Jacob. C

stantrolav
Contributor II

Re: Chart Calculation issue in Qlik Sense

Ok. Try this one:

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

sibin_jacob
Contributor III

Re: Chart Calculation issue in Qlik Sense

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