Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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
Highlighted
Partner
Partner

Use this:

not IsNull(GetFieldSelections(EFF_DATE))

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

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".

Highlighted
Partner
Partner

count(distinct EFF_DATE)=1

Highlighted
Creator III
Creator III

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.

Highlighted
Partner
Partner

as said : count(distinct EFF_DATE)=1

Example:

Capture.PNG

One year is selected :

Capture.PNG

> 1 year selected :

Capture.PNG

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

Ok. Try this one:

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

Highlighted
Creator III
Creator III

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