Welcome to Qlik Community

Hi Everyone,

I am trying to set the background color based on the IF statement. I'm not sure if I can combine multiple conditions within the IF statement or not? Because calculation works fine when I run it separately along with the indicator, it doesn't work while I combine it with the IF clause. Please see the calculation below, and help me with fixing it. I have set up the indicator as a variable.

if (Only({<Goal_Metric={'Computer'}>} [Goal]) > sysvalue >= Sum({< Plan_Quarter ={'$(=MaxString(Plan_Quarter))'},[Plan_Metric]={'Computer'}>} [Plan_Value]), '$(vC_LightIndicator)')

Note: sysvalue is also a calculated field.

I'm trying to calculate if goalvalue > sysvalue >= planvalue then show this background color

Any suggestion is greatly appreciated!

Hi ,

I am replicating data from Salesforce to MSSQL.

When I start the task it runs successfully but when I stop the same task and resume it I get the below error.

on checking the logs I get the below error.

Thanks & Regards,

Nikhil Raorane

Hi All,

Can some help me with below scenario..

I have 2 tables 

1. Employ table with employ no, country and date(date when he was present in that country).

  2. Insider table with employ no, incident number(issues he worked on) and incident_created_date(when that issue was raised).

Now i want to join both the tables and get Country field in Insider table. 

Based on Incident_Created_date <= Emp_Start_Date

i.e.  for Incident_Created_date <= 17/05/2008 Country should be UK

         Incident_Created_date <= 04/02/2009 Country should be US

        Incident_Created_date <= 09/07/2010 Country should be AUS

Thanks in Advance,

I'm trying to create a cumulative sum for YTD based on a user's selection

The user selects PeriodYear (an integer value), PeriodMonth (integer from 1-12), so I would like the sum(Amount) from month 1 to the users selection. I've been trying solutions suggested online and I simply can't get this to work, any help would be really appreciated.

Getting below error after I run my task to replicate data from MSSQL db to Azure synapse analytics.

Hii Guys,

I have pie chart, I want to show the previous quarter values in pie chart without any selection by expression its change dynamic,when user open the dashboard ,with selection it's show accordingly.

Can help me this anyone please.

Thanks in advance.

Regards,

Subba

Does anyone know how to load and render images from some database in Qlik Sense?

I tried to follow steps from the brochure "Qlik Sense Loading Images from Databases", but didn't get any result (Map Object doesn't render anything).

I need to load only rows which fall into the top 4 values in a field

Risks:

So for the above table, I only need to load RiskID 1234, 1236, 1237, 1239, 1240 as the scores fall into the top 4 for the field

|Regards

I'm a little embarrassed to be asking, but I'm having some issues creating a year to date sum using Set Expression.

I have a field Amount that I would like to do a YTD sum, with dates ranging from 01/2021 to 12/2021 called FinPeriod. I've been scratching my head all afternoon trying to come up with the expression and it's just not coming together, could someone please point me in the right direction?

Cheers