Am trying to run below script but its giving me Field 'ID_DATE_NUM' not found error. Below is the script please help

PDT_DTL :

Load *,Date(Date#(ID_DATE_NUM,'YYYYMMDD'),'DD/MM/YYYY') as REPORTING_DT,
num(Date(Date#(ID_DATE_NUM,'YYYYMMDD'),'DD/MM/YYYY')) as %KeyDate;

SELECT
CAT,
ID_DATE_NUM,
ID_DATE,
REVN_SUB_TYPE,
RGN,
AREA,
OS,
SGMN,
SUBS,
SUB_MPS,
VOL,
VOL_MPS,
VAL,
VAL_MPS,
REV,
REV_MPS
FROM
TEMP_DASH_2022

Trying to find a better way to search for content in my apps.  In each app, there are many sections in the Load Editor area.  I thought that I could use tags so that I can search which app has the content better, but in Qlik Cloud, I don't see a way to search for the tags.  Also, the tags option only show up when I publish an app.

What are tags use for in Qlik Cloud?  Other than the app name, is there another way to help search for the Sections in the app Data Load Editor screen?

I have several notes that start one day and end the next. I need to calculate and the rule is start greater than 16h and end less than 16h.
Example:
func, oper, dt ini time, dt end time,
A, 1, 06/26/2022 22:00, 06/26/2022 22:50
A, 2, 06/27/2022 01:00, 06/27/2022 04:30
A, 3, 06/27/2022 17:00, 06/27/2022 22:00
A, 4, 06/28/2022 20:00, 06/28/2022 23:00
A, 5, 06/29/2022 03:00, 06/29/2022 14:00
B, 1, 06/26/2022 22:00, 06/26/2022 22:50
B, 2, 06/27/2022 01:00, 06/27/2022 04:30
B, 3, 06/27/2022 17:00, 06/27/2022 22:00
B, 4, 06/28/2022 20:00, 06/28/2022 23:00
B, 5, 06/29/2022 03:00, 06/29/2022 14:00

Desired result:
Func "A" on the 26th = from 22:00 on the 26th to 04:30 on the 27th
func, day, total hours
A, 26 06:30
A, 27 05:00
A, 28 18:00

Hello,

I would like to add a column in the data load editor.

I have 2 products, product 1 and product b. for these i have 3 columns with dates. Date C, Date D and date E.

newcolumn = if product A, Date D - Date C, if product B, date E - date C

can somebody help me with the syntax?

Hi There,
On my dataset I have a constrain that only shows dates after 31/03/22.

As you can see, when I hover over the first data point it shows that the date is 01/04/22 - I am wondering why the Line chart X axis which is a week ending number is showing 27/03/21.

I had a look and I can confirm that in the data I don't have anything earlier than 01/04/22.
Does anybody know how I can achieve this?

Bom dia,

Estou tentando fazer uma soma acumulada que traga o total mas que respeite os filtros que eu selecionar, e preciso desconsiderar o campo centro de custo =000.

No exemplo para a data 01/02/2022 preciso trazer o valor de 1089.(que no teste filtrando o período não funcionou)

só que quando seleciono o centro de custo à ignorar, o campo total acumulado 2(minha tentativa) não funcionou em trazer o 1089 da soma simples anterior.

Anexei um qvd com dados similares.

Hi All,

I have a variable and I have 2 total values in this variable.

the content of my variable Test2; sum(grosstotal) + sum (grossamount)

My expression =  Sum({<PERNUM = {"=Sum([$(vTest2)]) > 0"}>} $(vTest2)) but is not working.

What I want to do here is to bring the data of the personnel except the zero sum.

how can i use the variable here please help