Hello,

With the current version of qlik sense if I have users that have created community sheets that are published, how can I add them to the dashboard as base sheets?

I thought there was an approve option?

Thank You,

Michael

Hi experts,

I would like to know if there is a way to load selected files that are listed in another table, and ignore others.

My situation is as follow.

• The QS is loading files from the folders organized by date.
  Ex. C:\Data\YYYYMMDD\BOM_ProductNumberXXX.xls
• The users will upload the files as when the new files are available.
• There is  MasterPlan.xls that contain all the in-scope products, along with other info for each products. This spreadsheet is loaded into the QS.

What happen is that the users are not following the list of the products in the MasterPlan and there are files that not required being uploaded as well. 

Here is my load scrip.

TableMasterPlan:

LOAD
Site,
Business,
PLC,
Trim(Products) as Products,
ProductDescription,

FROM [$(vRefTablePath)/MasterPlan.xlsx]
(ooxml, embedded labels, table is MasterPlan);

FOR Each vDir in DirList('$(vDataPath)/*')

FOR each vFile in filelist (vDir&'\*.xls' )

Table:

LOAD Distinct
TRIM(Mid(filebasename(), 16)) as Products,
Date(Floor(FileTime())) as ReportDate,
@13 as SpecID,
@2 as MatlNumber,
@3 as MatlDescription,
@14 as "Spec. Type"
FROM [$(vFile)] (biff, no labels, header is 10 lines)
Where @14='MAT_PART_E';

Next vFile

Next vDir

Appreciate any suggestion that you may have to modify the load script to load just the products listed in the MasterPlan table. For ex., if there are 50 files in the folder, and the Masterplan has 20 products, the load script will load the files matching the Products in Masterplan, and skip others.

Hello dear Experts,

I want ot load data with the next logic:
I have a field called "Account" which contains many logs who start with this structutre "x11000-0000-0000", "x11000-1000-2000", etc.

Is that possible to make a wildcard to load all the data of this field which start with "x1100*" like a wildcard load or something?

Im setting some operation into the the script which contemplate many logs of this fields, but put every row that i want of this field could be a really long operation, thats why im looking to use something like a wildcard load.

Example:
[Account ID] = 'x11000*' / [Account ID] = 'x21000*' as RazonCirculante

I would greatly appreciate your help.

Regards.

Hey community!

I've been struggling to define a data range as set modifier. This set analysis syntax works:

=Sum ({1<Attribute={F_2020_02,F_2020_03,F_2020_04,F_2020_05,F_2020_06,F_2020_07,F_2020_08,F_2020_09,F_2020_10,F_2020_11,F_2020_12,F_2021_01}>} Value)

It looks at an Excel with an Attribute column that holds month information: F_2020_1 is 1 January 2020 and so on. The goal is to have the date values adapting according to today's date so it can always look back 12 months.

I tried defining the attribute range in the loading script as such:

Let SavingMeterDateRange = 'F_'&Date(Today()-334,'YYYY_MM')&',F_'&Date(Today()-306,'YYYY_MM')&',F_'&Date(Today()-275,'YYYY_MM')&',F_'&Date(Today()-245,'YYYY_MM')&',F_'&Date(Today()-214,'YYYY_MM')&',F_'&Date(Today()-184,'YYYY_MM')&',F_'&Date(Today()-153,'YYYY_MM')&',F_'&Date(Today()-122,'YYYY_MM')&',F_'&Date(Today()-92,'YYYY_MM')&',F_'&Date(Today()-61,'YYYY_MM')&',F_'&Date(Today()-31,'YYYY_MM')&',F_'&Date(Today(),'YYYY_MM');

Which does correctly result in:

F_2020_02,F_2020_03,F_2020_04,F_2020_05,F_2020_06,F_2020_07,F_2020_08,F_2020_09,F_2020_10,F_2020_11,F_2020_12,F_2021_01

But when applying this to the syntax, the result is zero. I guess that's because it's not recognized the same way. How can I make Qlik Sense understand that it should look for the resulting attributes?

Hello,

after deleting files in the folder C:\ProgramData\QlikTech\QlikViewBatch, "something" happened with the QlikView server.

1) All tasks are not visible - they exist and run as planned, but in 'Status' we cannot see the tasks

2) In System/Setup/QlikView Server, two Server exist. One of them sends an error

Do you have an idea how we can solve this situation?

@Albert_Candelario?

Best regards, Patrick

Need to plot bar chart to compare weighted average hours for 2020 vs 2019 Products.

1) Calculate weighted average hours for2020 Products

2) Calculate weighted average hours for 2019 Products if 2020 Products QTY is greater than 0.

which mean for product E, sum of 2020 QTY is 0. It is excluded from 2019 weighted average.

Below is the correct value:

Hi All,

I am trying to display a box plot for two experimental group fields, but getting weird error which I could not resolved and provided below. 

Sample of the data

If anyone knows what is the problem please let me know

Thank you