Recent Discussions
-
Tiempo de carga SQL Server - Qlik Cloud
Tengo una conexión a SQL en Qlik Cloud, la tabla resultante tiene aproximadamente 6 millones de datos. Normalmente tardaba 1 hora en realizar la recar... Show MoreTengo una conexión a SQL en Qlik Cloud, la tabla resultante tiene aproximadamente 6 millones de datos. Normalmente tardaba 1 hora en realizar la recarga, de un momento a otro el tiempo de recarga aumento al punto de que el script de carga aborta por exceder el tiempo máximo (3 horas). Hablé con los dueños de la base de datos y ellos me indican que no se realizó ninguna modificación en esta. Por otro lado, al realizar esta misma conexión pero en Qlik Sense On Premise la recarga de datos se completa satisfactoriamente.
¿A qué se puede deber esto?
-
Filtering NULL Values in Qlik Replicate
Hi Team,I want to filter out records as per the below condition:The cardnumber from source which has null values should not be pushed to target. Only ... Show MoreHi Team,
I want to filter out records as per the below condition:
The cardnumber from source which has null values should not be pushed to target. Only cardnumber which holds field values should be pushed. How can I achieve this. -
要約統計量を並べたテーブルの作成
お世話になります。Qlik Senseのクラウド版を使用しております。添付のようなテーブルを作成しようと考えていますが、Qlik Senseでは可能なものでしょうか。可能な場合、どの機能を使えばよろしいでしょうか。(シート→チャート→テーブルで行けるものでしょうか。)ご教示いただけますと幸いです。(... Show Moreお世話になります。
Qlik Senseのクラウド版を使用しております。
添付のようなテーブルを作成しようと考えていますが、Qlik Senseでは可能なものでしょうか。
可能な場合、どの機能を使えばよろしいでしょうか。
(シート→チャート→テーブルで行けるものでしょうか。)
ご教示いただけますと幸いです。
(必要な項目が載っていれば、テーブルの形は多少崩れても構いません。)恐れ入りますが、よろしくお願いいたします。
-
Automatic Loading of Excel Files form a folder connection through Script
Hi. I have a folder connected to my Qlik Sense Enterprise cloud where i have placed multiple excel files. My excel files contain multiple sheets with ... Show MoreHi. I have a folder connected to my Qlik Sense Enterprise cloud where i have placed multiple excel files. My excel files contain multiple sheets with each sheet has different data and different number of columns. The problem arises when i try to upload them automatically using the script. It only loads the first sheet and gives an error in loading other sheets. what should be included in script for load multiple sheets from an excel file?
Currently the load script which is working fine to load single sheet file is below:
SET vFolderPath = 'lib://....*...*...';
FOR Each vFile IN FileList('$(vFolderPath)\*.xlsx')
TRACE Loading File: $(vFile);- LOAD *
FROM [$(vFile)] (ooxml, embedded labels, header is 1 lines);
NEXT vFile
- LOAD *
-
How to get Space -> Apps -> Sheets information into a QVD file using single Auto...
I am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to... Show MoreI am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to achieve this in Qlik Sense SaaS version please.?
Ex. I need to create a table like below
SpaceName AppName SheetName SheetType
Dev Test Space_App_Sheets Public
Prod Test1 Demo Private
-
Remove the entire row when measure returns 0
Hi All, I need to remove the entire row when something returns null. While working with dimension, unchecking the include null values works perfectly,... Show MoreHi All,
I need to remove the entire row when something returns null. While working with dimension, unchecking the include null values works perfectly, The similar action I need to perform in a measure.
This is the final table that I am seeing now
APM NUMBER PRODUCT Fiscal year period Total cost Product Specific sum 123 Apple 2020001 3 $3 123 Apple 2020002 0 - 123 Apple 2020003 3 $6 456 Apple 2020001 4 $10 456 Apple 2020002 5 $15 456 Apple 2020003 6 $21 678 Apple 2020001 1 $27 678 Apple 2020002 0 - 678 Apple 2020003 3 $30 910 Banana 2020001 1 $1 910 Banana 2020002 2 $3 Here the total cost column is a sum(field 1 +field2) so it always returns 0 if there is sum(null,0), While calculating cumulative cost the calculations are performed rightly but this issue happens.
Now I want to remove the entire row that returns - ,how to do that?
I tried the combination of if and not isnull but those return the same table.
Has anyone faced this issue? Please help me resolving this
Regards,
Keer
-
App Active Status
Hello ExpertsI have a client inquiry concerning their Qlik Sense SaaS environment where we've recently deployed 20 dashboards. These dashboards are st... Show MoreHello Experts
I have a client inquiry concerning their Qlik Sense SaaS environment where we've recently deployed 20 dashboards. These dashboards are static, with data loaded only once at deployment and no subsequent refreshes planned.Could you recommend a tool or method to monitor the health of these dashboards daily in the Qlik Sense SaaS environment ?
Basically I wanted to check if the 20 dashboard is active and Its up and running.
I am not interested in checking the RAM usage or reloads or numbers of Users using dashboard or Synthetic keys. I wanted to check only the status of the dashboard if it is active and up running on Qlik Saas.
Based on the above requirement which tool can perform this in Qlik.
Thank you! -
Qlik Sense Table chart with one of the columns split up in multiple rows
Hi ev'ryone, I'm trying to build a table in Qlik Sense that has 26 columns (each bound to an ID) plus two more column (Year + Measure) that shall have... Show MoreHi ev'ryone,
I'm trying to build a table in Qlik Sense that has 26 columns (each bound to an ID) plus two more column (Year + Measure) that shall have multiple rows (one for each year). So what I want is one row for the ID and the 25 following columns and then that row splitting into one row for each year and the value/measure for the respective year.
Somehow it seems that Qlik Sense won't let me create such a table.
In Qlikview this was no problem (see the screenshot to have an idea how it shall be)Can anyone help, please?
Thank you in advance 🙂 -
Cumulative Sum based on Aggr()
Hi All, I have a sample data as APM NUMBER PRODUCT Fiscal year period Total cost 123 Apple 2020001 1 123 Apple 2020002 2 123 Apple 202... Show MoreHi All,
I have a sample data as
APM NUMBER PRODUCT Fiscal year period Total cost 123 Apple 2020001 1 123 Apple 2020002 2 123 Apple 2020003 3 456 Apple 2020001 4 456 Apple 2020002 5 456 Apple 2020003 6 678 Apple 2020001 1 678 Apple 2020002 2 678 Apple 2020003 3 910 Banana 2020001 1 910 Banana 2020002 2 Here the cumulative sum must restart for each new product, but should not change even if the products' APM number is changed(the sample output is given at last). I performed the cumulative sum as
NUM(
Aggr(
RangeSum(
Above(
Sum({1}{$}[Total cost]),
0,
RowNo(Total)
)
),
PRODUCT,[APM NUMBER]
),
'$#,##0'
)I got the result as
It works but it gives null values because of aggregation . I need my resulting table as
Here I need the Product Specific cumulative Sum as required
APM NUMBER PRODUCT Fiscal year period Total cost Product Specific sum 123 Apple 2020001 1 $1 123 Apple 2020002 2 $3 123 Apple 2020003 3 $6 456 Apple 2020001 4 $10 456 Apple 2020002 5 $15 456 Apple 2020003 6 $21 678 Apple 2020001 1 $27 678 Apple 2020002 2 $29 678 Apple 2020003 3 $32 910 Banana 2020001 1 $1 910 Banana 2020002 2 $3 Has someone face this issue, Please help me understanding this.
Regards,
Keer
-
Data Types issue when compared to Enterprise and SaaS Cloud
Hi All, We are tried to add one of the field that has mixed data types and when it comes to enterprise the the text is showing ion the left alignment ... Show MoreHi All,
We are tried to add one of the field that has mixed data types and when it comes to enterprise the the text is showing ion the left alignment and num is right alignment which is an expected scenario but when we are trying to load same set of data on the Qlik cloud its treated everything as a text and showing as left alignment.
is there a way to fix this issue without using dual function?
Regards,
Raju