Recent Discussions
-
Set analysis on concatenated fact data
Hi,I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to c... Show MoreHi,
I have fact data that needs to be concatenated and because of several reasons I cannot join the columns. So for the example below I would like to calculate with Set analysis the number of issues per Category, but it should calculate as follows:
for Category A : 2 (Issue X and Y) + 1 (Issue linked through Order M)
I believe it is possible with P function in Set analysis, but I cannot succeed with it.. appreciate any help
-
Qlik Replicate Source IBM DB2 for iSeries port connection
Hi,I have a connection source in replicate using IBM DB2 for iSeries, and use these connection properties with IP address,Is posible configure the IP ... Show MoreHi,
I have a connection source in replicate using IBM DB2 for iSeries, and use these connection properties with IP address,
Is posible configure the IP address and especified a port number to connection?
thanks, -
Why is the 'Open File' block deemed third party?
I am using the 'Open File' block to pull a file from an app's content library (via HTTP), and automations is deeming this a third-party block?I've tri... Show MoreI am using the 'Open File' block to pull a file from an app's content library (via HTTP), and automations is deeming this a third-party block?
I've tried with the Raw API Request block using
apps/{APP_ID}/media/files/{FILENAME}.png
as the path, but it returns nothing. I'm assuming because per the API docs, it's expecting the --o tag, which I can't add in the block?Is there a better way to do this?
Maybe a dev request to have 'Qlik Cloud Services' added to the connector options in the Open File block? -
Styling New Straight Table With Custom Theme
Within the "New" Straight Table, is it possible to use a custom theme (within the JSON file) to set default styling on the Header, Dimension Values, M... Show MoreWithin the "New" Straight Table, is it possible to use a custom theme (within the JSON file) to set default styling on the Header, Dimension Values, Measure Values, Total Row, etc.?
I was able to deduce that the object's reference is sn-table and am able to customize the "Main" section (Headers, footers, etc.) but I haven't been able to locate any documentation for the rest of the Styling options.
I imagine the format would be something like this, but no combinations/arrangement that I've tried seem to work
"sn-table": {
"dimension":{
"values":{
"fontSize":"16px",
"color":"#FFFFFF",
"background":"#326F91"
}
}
}Any assistance would be much appreciated. Thanks in advance!
-
Is it possible to schedule Qlik Cloud Monitoring Apps Installer?
I am using the Qlik Cloud Monitoring Apps Installer automation to install new versions of the various monitoring Apps. I wanted to add a schedule to ... Show MoreI am using the Qlik Cloud Monitoring Apps Installer automation to install new versions of the various monitoring Apps.
I wanted to add a schedule to this automation, but since the automation requires Input, when I add schedule details, it fails with the message I have attached as pic
I am also very new to this, so it's probably something fundamental that I am missing. Has anyone done this successfully? If yes, any/all guidance would be truly appreciated.
Thank you
-
円グラフに頻度と%の両方を同時に表示する方法
お世話になっております。現在、Qlik Senseで円グラフを作成しており、「頻度(count)」または「割合(%)」のどちらか一方しか表示できない状況です(マウスオーバーすれば両方見られます)。これを、頻度と割合の両方を同時にラベルとして表示する方法はありますでしょうか?理想としては、以下のような... Show Moreお世話になっております。
現在、Qlik Senseで円グラフを作成しており、「頻度(count)」または「割合(%)」のどちらか一方しか表示できない状況です(マウスオーバーすれば両方見られます)。
これを、頻度と割合の両方を同時にラベルとして表示する方法はありますでしょうか?理想としては、以下のような形式で改行を入れて表示したいと考えております:
xx(xx.x%)ラベルの表示位置やグラフの形(円グラフ or ドーナツグラフ)については特にこだわりはありません。表示位置も、円の内側でも外側でも構いません。
なお、countを使ってグラフを作成していますが、
たとえば以下のような数式で対応できるかどうかも検討しています:count([xxx]) & count()/sum() & "%)"もし他に適切な方法や推奨されるやり方がありましたら、ご教示いただけますと幸いです。
どうぞよろしくお願いいたします。 -
Limiting Denominator to only dates where numerator has a value
Need some help with a formula. We have a dashboard that shows KPIs for sales and transactions data by discount code. On this dashboard the users can f... Show MoreNeed some help with a formula.
We have a dashboard that shows KPIs for sales and transactions data by discount code. On this dashboard the users can filter through different discounts and see information such as sales, transactions, unique customers, etc. They also want to see discounted sales as a % of total sales on the days where there was a transaction with that discount code used.
This is where I'm having some trouble. If we just look at calculating the denominator, I need a formula that takes every transaction in the days that there was a transaction for the selected discount codes.
Here's an example of what I'd want:
Date Discount Code Transaction ID Sales
4/24/2025, Discount-A, 111, $10
4/24/2025, N/A, 112, $15
4/23/2025, Discount-A, 113, $12
4/23/2025, N/A, 114, $11
4/22/2025, N/A, 115, $9
This is what I've tried as a formula for the denominator:
IF(GetSelectedCount([Discount Code])>=1,
sum({$<[Discount Code]=>}Sales)
)For this I would want the sum of sales for 4/23/2025 and 4/24/2025, excluding the sales from 4/22/2025. So the total should be $48. The formula actually gives me a value of $57. I was thinking I need something like:
Only({<SUM(Sales)>={1}>} Date)
in the set analysis. That should work because this KPI has a condition to only show if a selection is made in the discount filter. When no selection is made all the KPIs on the page are blank (intended).
Any ideas on this?
-
Talend jobs getting failed while running in TMC
Hi teamI am not able to run the jobs in TMC as I am getting the following error:There was an error with the engine. Contact an infrastructure adminis... Show MoreHi team
I am not able to run the jobs in TMC as I am getting the following error:
There was an error with the engine. Contact an infrastructure administrator to review the status of the engine.The jobs were running fine without any issues till last day. Please let me know how this issue can be rectified.
Thanks
-
NPrinting Server : .net 4.8 installation error
Hi All, I'm setting up new Server for NPrinting as my old server was on Windows 2016. I'm trying to install .net 4.8 in new Server,it doesn't have Npr... Show MoreHi All,
I'm setting up new Server for NPrinting as my old server was on Windows 2016.
I'm trying to install .net 4.8 in new Server,it doesn't have Nprinting Server/Engine installed.
I'm getting error while installing the .net framework 4.8 for windows 2019 server
Error message: 0x80092004 -can not find object or property
Can anyone suggest what could be the issue?
Error is attached.
Thanks in advance
-
Export all the variables with automation
Hi,I would like to export all my variables in the app to Excel file. How can I do with the automation in Qlik cloud ? Opens in new windowPDF Downloa... Show MoreHi,
I would like to export all my variables in the app to Excel file.
How can I do with the automation in Qlik cloud ?
Opens in new windowPDF DownloadWord DownloadExcel DownloadPowerPoint DownloadDocument DownloadOpens in new windowPDF DownloadWord DownloadExcel DownloadPowerPoint DownloadDocument Download