Hello.

I am trying to calculate the year to date average based on year selected. I do have a Master Calendar with a YearMonth field.

I would like to build a Set Analysis expression so that when certain criteria are fulfilled it calculates my average.

Below is a sample of data where the average value should fall in the Completion Month. As shown in the data, January value will be zero, anyway to force the zero in the chart when there is no value as well (null).

Criteria for the Set analysis expression is:

Products (All)

Product Type (Mens, Women)

YTD Average of days based on End Date.

I need to convert a timestamp from UTC to the time zone where the event occurred and then create a field that says whether that time is in Business Hours or After Hours. This is the calculation I currently have for this but it times out when I put it into a visual:

=IF((HOUR(ConvertToLocalTime(call_start_time, time_zone)) >= 8 AND HOUR(ConvertToLocalTime(call_start_time, time_zone)) <= 17), 'Business Hours', 'After Hours')

I have also tried creating a measure called Call Local Time that is:

ConvertToLocalTime(call_start_time, time_zone)

then plugging this calculation into

=IF((HOUR(Call Local Time)) >= 8 AND HOUR(Call Local Time)) <= 17), 'Business Hours', 'After Hours')

The problem is that with the measure being plugged into the dimension the result doesn't seem accurate as it starts calling everything After Hours despite there actually being more of a 50/50 split between after hours and business hours. 

I was wondering if its possible to write the calculation in the Data Load Editor and if so, how would I do it? 

I am attempting to implement a writeback function. First, I am attempting to link an input box to individual values in a table. My ultimate goal is to select a value in the table, type a new value in the input box, click a button and the value with be updated in the selected table..

Hi,

I have a fact table (f_table) and dimension table (d_table) with below fields.

f_table: country_cd, measure_1

d_table: country_cd, country_desc

In Qlik Sense data manager, I associate both the tables on country_cd field. 

Now I add a bar chart to display measure_1 against country_desc. There are many country codes in my fact table which are not in dimension table. All these are displayed against '-' in my bar chart. But I want to display it as 'Unknown'.

I tried changing the dimension (in bar chart) from just "country_desc" to "if(isnull(country_desc), 'Unknown',country_desc)" but it does not help.

Appreciate any suggestions. Thanks!

Today we had an error on one of our Qlik Replicate tasks "Failed to remove file:" 
Processing aborted due to error 300002:1355844283; incident 3722464.
to execute statement: REMOVE @"PROD"."PUBLIC"."ATTREP_IS_PROD_bf071f72_b1f9_4dc7_b2f8_919759658d9c"/bf071f72_b1f9_4dc7_b2f8_919759658d9c/0/CDC00000215.csv;

What does this error mean?