Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
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 ?
I am creating a report in NPrinting, but I am not able to bring the data of some specific fields, they are in date and percentage format, NPrinting can bring the formatting, but it is not bringing the values, can anyone imagine the reason?
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日(水)に厚生労働省のサイトで令和3年度(R3)のDPC調査結果(令和3年度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.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!