Hello,

I would like to know if there is a way to save down the entire qliksense report as daily copy? This is the need for our daily reporting process that needs to keep a daily copy of the report.

To be specific, the report includes several sheets, we need to save the entire report/app daily with a date stamp, not just one specific sheet or one specific table in the sheet.

Thank you.

A table has 18 columns and many rows.

I cannot export to excel, when I try I just get a grey cross across the table. 

Even if I only select a single row it does the same thing. 

If I remove a random 4-5 columns it then works. 

How do I fix it?

Thanks!

hi all,

my set analysis is working properly when one value is selected, but it does not work on the whole selection.

to determine timetable_id i am using:

ONLY({1<STARTDATE = {'$(=$(vStartdate))'}>}timetable_id)

where vStartdate = max(if(STARTDATE<(vPeildatum)+1,STARTDATE))

this is my data load:

LOAD
"PK_R_EMPLOYEE" as Employee_id,
CODE as Employee_code;

SQL SELECT
"PK_R_EMPLOYEE",
CODE
FROM ".dbo."V_R_EMPLOYEE";

tbl_timetable:
LOAD "FK_EMPLOYEE" as Employee_id,
"FK_TIMETABLE" as timetable_id,
date(STARTDATE) as STARTDATE;
SQL SELECT "FK_EMPLOYEE",
"FK_TIMETABLE",
STARTDATE
FROM "V_R_TIMETABLEOFFSET";

left join tbl_timetable:
LOAD "FK_TIMETABLE" as timetable_id,
"FK_WORKDAY" AS WORKDAY_ID,
SEQUENCENR,
"PK_R_TIMETABLEWORKDAY";
SQL SELECT "FK_TIMETABLE",
"FK_WORKDAY",
SEQUENCENR,
"PK_R_TIMETABLEWORKDAY"
FROM "V_R_TIMETABLEWORKDAY";

left join tbl_timetable:
LOAD CODE,
DESCRIPTION,
(DEFAULTHOURS/10000000)/(60*60) AS DEFAULTHOURS,
"PK_R_WORKDAY" AS WORKDAY_ID;
SQL SELECT CODE,
DESCRIPTION,
DEFAULTHOURS,
"PK_R_WORKDAY"
FROM "V_R_WORKDAY";

how can i fix this?

kind regards,

Simon de Vrieze

Hello,

I have an issue with proper filtering data table.

I have also asked chatGPT but he can't clear this.

I need filtered this table:

 1 I need only December 2022 and later included

 2 I need exclude any row with "COR" contained in field H_DOCUMENT_NUMBER

There is probably syntax error with stacking two where clauses but single try  with only excluding "COR" don't work as demand too.

LOAD
'SALES' as TABLE,
H_DOCUMENT_NUMBER as DOCUMENT_NUMBER,
CUSTOMER_ID,
MATERIAL as "FG Code",
//"Short model name" as "Short model",
H_TO_NET_EUR as "TO NET",
DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') as CAL_YYYY_MM,
TO_REGION

FROM [lib://QVD tabele:DataFiles/SCEP_ALL_AN_SALES.QVD]
(qvd) WHERE DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') >= '2022_12'
OR NOT H_DOCUMENT_NUMBER LIKE '%COR%';

Hello,

i have a table, which contains multiple fields, but at the frontend, i only want to show one certain field.
The source data looks like this:

at the frontend, i want it to look like this (only show Amber):

can you guys help me?

I have two problems. I need to grab a field with my set analysis from outside my dimension. I'm pretty sure I've done this before but I cannot seem to find the function that allows that anywhere, after about 3 days straight of scouring and reading documentation.

The second issue I have is just a simple syntax problem on the value I'm trying to gather above. Here is a snippet of my formula from my table:

=aggr(     // I don't know if this is necessary at all
Concat({<    // I have also tried Only() here with no success
[Transactions.Ref Number] = ExpressionVariablePlaceHolder,     

Transactions.Memo={"*Sales Order*"}
>}
Transactions.Memo // This value is never displayed, if I remove the Aggr() encapsulation I get "error in calculated dimension
),''
)

I need to grab all lines under [Transactions.Ref Number] and extract the one that contains "Sales Order: XXXXX". Currently each line of Transaction shows up as a separate row and only one contains the "Sales Order: XXXXX" Transactions.Memo value, all other rows show it as blank which is why I have to grab it outside the dimension of each row.

Any help would be greatly appreciated!

Hi Experts,

Need small help in rounding off the numbers as below. the percentage number fractional number less than 5 then it should be ceil else round 

Hi,
I was asked if it is possible to deny the access to a single app without using section access?
The user should see the stream, but should not see a particular app inside the stream?
Thanks in advance