Hello,

I can connect to sharepoint via metadata connector to get "filelist"

But what to do in case i have files in different subfolders (some wildcard)?

/sites/05_BUSINESSPLANNING/Shared Documents/06_Price List/03_SAS'

Contains subfolders: "2021", "2022", "2023" and every subfolder contains another subfolder related to Quarters.

At the end I have similar tables with matching columns within 5 sheets i every excel file.

Is there any option to do this LOAD ? 

LIB CONNECT TO 'DA_CONNECTORS:SHP_metadata';
List_of_SASPRICELIST_FILES:
LOAD UniqueId as [ListFiles.UniqueId],
Name as [ListFiles.Name],
title as [ListFiles.title],
id as [ListFiles.id],
updated as [ListFiles.updated],
Author_Entry as [ListFiles.Author_Entry],
CheckedOutByUser_Entry as [ListFiles.CheckedOutByUser_Entry],
EffectiveInformationRightsManagementSettings_Entry as [ListFiles.EffectiveInformationRightsManagementSettings_Entry],
InformationRightsManagementSettings_Entry as [ListFiles.InformationRightsManagementSettings_Entry],
ListItemAllFields_Entry as [ListFiles.ListItemAllFields_Entry],
LockedByUser_Entry as [ListFiles.LockedByUser_Entry],
ModifiedBy_Entry as [ListFiles.ModifiedBy_Entry],
Properties_Entry as [ListFiles.Properties_Entry],
VersionEvents_Feed as [ListFiles.VersionEvents_Feed],
Versions_Feed as [ListFiles.Versions_Feed],
CheckInComment as [ListFiles.CheckInComment],
CheckOutType as [ListFiles.CheckOutType],
ContentTag as [ListFiles.ContentTag],
CustomizedPageStatus as [ListFiles.CustomizedPageStatus],
ETag as [ListFiles.ETag],
Exists as [ListFiles.Exists],
IrmEnabled as [ListFiles.IrmEnabled],
Length as [ListFiles.Length],
Level as [ListFiles.Level],
LinkingUri as [ListFiles.LinkingUri],
LinkingUrl as [ListFiles.LinkingUrl],
MajorVersion as [ListFiles.MajorVersion],
MinorVersion as [ListFiles.MinorVersion],
ServerRelativeUrl as [ListFiles.ServerRelativeUrl],
TimeCreated as [ListFiles.TimeCreated],
TimeLastModified as [ListFiles.TimeLastModified],
UIVersion as [ListFiles.UIVersion],
UIVersionLabel as [ListFiles.UIVersionLabel];

SELECT UniqueId,
Name,
title,
id,
updated,
Author_Entry,
CheckedOutByUser_Entry,
EffectiveInformationRightsManagementSettings_Entry,
InformationRightsManagementSettings_Entry,
ListItemAllFields_Entry,
LockedByUser_Entry,
ModifiedBy_Entry,
Properties_Entry,
VersionEvents_Feed,
Versions_Feed,
CheckInComment,
CheckOutType,
ContentTag,
CustomizedPageStatus,
ETag,
Exists,
IrmEnabled,
Length,
Level,
LinkingUri,
LinkingUrl,
MajorVersion,
MinorVersion,
ServerRelativeUrl,
TimeCreated,
TimeLastModified,
UIVersion,
UIVersionLabel
FROM ListFiles
WITH PROPERTIES (
subSite='sites/05_BUSINESSPLANNING',
folder='/sites/05_BUSINESSPLANNING/Shared Documents/06_Price List/03_SAS',
maxResults=''
);

Hi All

In a dashboard I create a nice report but I want to combine this with an existing report.

The external two-pages pdf should become some kind of object that will be embedded into my style. Is this possible?

Even better would it be that I could define the exact two positions on a page so that the source can be cropped to those two points.

Anyone who had to deal with such a challenge?

Thanks,

Alex

I have a NP report which cycles on a field called Program Name. When I publish it to hub, I see that the Report name is Report-ProgramCode and not the friendly name that I have given in the publish task. Is it possible to have the Friendly name shown in the Hub Reports area ? also can we create a folder structure under Reports area in the hub and publish to the hub in the folder ?

Hi,

I have created an object in Qlik Sense with monthly running totals.

I then created a pixel perfect report where I add my table in a level.

I now have 2 problems:

1. the values shown are the values of each months and not the running totals, thus I have to format a sumreport to get the correct values

2. I have a column which calculate the difference in percentage (Year N - Year N-1)/Year-1 And it does not work.

For instance, in february, I wanted ((January N + february N )- (January N-1+february N-1)/(January N-1+february N-1).

I only get (for february) (February N-february N-1) / February N-1.

Can anyone help please?

Thanks

Hello Everyone, We're using Qlik Sense .Net SDK (14.1.0) in .Net Core 3.0. We need to get  theme name of selected qliksense app but we can't find any solution. Does anyone know how to get theme name of qliksense app with .Net Core 3.0.

3月22日（水）に厚生労働省のサイトで令和３年度（R3）のDPC調査結果（令和３年度DPC導入の影響評価に係る調査「退院患者調査」の結果報告について）が公開されました。
https://www.mhlw.go.jp/stf/shingi2/0000196043_00006.html

昨年の公開データに比べ、施設数が416施設増えていましたが、全5732施設の住所、二次医療圏、位置（緯度経度）を施設概要表に追記しました。手順は以下の通りです。

〇追記等の手順
1.施設概要表の通番を利用して、昨年作成した施設概要表マスタ（住所、二次医療圏、緯度経度）の情報を付加
2.施設名が変更されており、移転や開院とわかるものは新住所の情報に変更
3.追加された施設は国土数値情報の医療機関のポイントデータを利用し、住所や緯度経度を取得。ない場合は、HPの住所からGoogle Mapで緯度経度を取得し追記。二次医療圏名も追加

住所や緯度経度は以下のサイトとGoogle検索を利用して情報を取得し追加しました。
〇医療機関（国土数値情報）
http://nlftp.mlit.go.jp/ksj/

2023年3月29日（水）の医療データ活用勉強会でも解説します。
https://techplay.jp/event/895905

添付のExcelファイルをダウンロードしてご利用ください。
ちなみに、Qlik Senseに取り込むと下図のように施設のポイントを地図上にあらわすことができます。

Hi All,

I am facing a bit weird issue . I have a straight table and a measure like below

=Sum([Purchase Amount]).

when I export the straight table in excel, and take the sum of Amount from the excel rows , the total shown in Qlik does not match with the total shown in excel rows. 

Though the diff is very major, but still it exists. Could it be a number format issue?

I have set the amount expression fixed to #,##0.00 (done from the Number tab)

Hi;

I have a stream, inside, there are three published applications.
I have two user groups:
both read the stream but a group can also export sheet data.

I knew how to implement the security rule for reading the stream but I didn't have to do the one for exporting data. 

Your help would be appreciated as I'm stuck.

BELA.