Recent Discussions
-
Upper function failed
Hi , the below expression is ok.however, if I use upper function, it failed.Count({<[Order Type Mini]={"<200"},[Order Type Mini]={">0"},upper([Order P... Show MoreHi , the below expression is ok.
however, if I use upper function, it failed.
Count(
{<[Order Type Mini]={"<200"},[Order Type Mini]={">0"},upper([Order Purchase Order Number])={'*TQBH*'},[Order Type Code]={'ZSTD','ZTTB'},[Fact_Type]={'FACT_ORDER'}>}
distinct [Order Document Number]
)why and pls help me check it .
-
Qlikview Pivot Table Column doesn't show
Hi, I made a modification to a QlikView app, adding a column to a pivot table, but there is a user that can't see the column, other users can. I thoug... Show MoreHi, I made a modification to a QlikView app, adding a column to a pivot table, but there is a user that can't see the column, other users can. I thought that the problem are the cookies of the browser, but the user logged in another PC and happend the same thing. Please help me.
-
License deallocation using automation in Qlik Cloud Analytics
Hi,does any one has idea how to deallocate the license for user using Raw api request block in qlik cloud analytics. Regards,Siva Prasad -
Start the Qlik Sense QMC job from another server using PowerShell script.
Hi Team,We have one Dummy Qlik Sense QMC job that is dependent on another server job where we are receiving the data. The QlikSense QMC job will be ex... Show MoreHi Team,
We have one Dummy Qlik Sense QMC job that is dependent on another server job where we are receiving the data. The QlikSense QMC job will be executed after the data has been refreshed from another server.
We have PowerShell script which is running fine in old server but when we trying to execute this PowerShell in newly migration server. Getting forbidden error.
Please find my script below.
cls $hdrs = @{} $hdrs.Add("X-Qlik-xrfkey","iX83QmNlvu87yyAB") $url = "https://Myserver/qrs/about?xrfkey=iX83QmNlvu87yyAB" #$response = Invoke-RestMethod -Uri $url -Method Get -Headers $hdrs -SessionVariable websession $response = Invoke-RestMethod -UseDefaultCredentials -Uri $url -Method Get -Headers $hdrs -SessionVariable websession $cookies = $websession.Cookies.GetCookies($url) $session = New-Object Microsoft.PowerShell.Commands.WebRequestSession $session.Cookies.Add($cookies) $response = @{} $hdrs = @{} $hdrs.Add("X-Qlik-xrfkey","iX83QmNlvu87yyAB") $url = "https://Myserver/qrs/task//start/synchronous?name=DummyJobForTrigger&xrfkey=iX83QmNlvu87yyAB" $response = Invoke-RestMethod -WebSession $session -Uri $url -Method Post -Headers $hdrs -ContentType 'application/json' $response.value -like "????????-????-????-????-????????????"
Error screenshot:
Could you please check and suggest ?
Regards,
Irshad Ahmad
-
Variable Not Working After Publish Qlik Sense App
New install of Qlik sense, new deployment.I have a dashboard with a variable that works before published. when i publish it, the variable stops workin... Show MoreNew install of Qlik sense, new deployment.
I have a dashboard with a variable that works before published. when i publish it, the variable stops working. others have reported this issue with no resolution, any ideas??
Shouldn't the app be EXACTLY the same pre-deployment as post-deployment??
-David
-
how to add a condition column in the loading script
HI, below is my origin data. there are different product in each orderin the loading script , I want to add a new column , if the product contain 'cat... Show MoreHI, below is my origin data.
there are different product in each order
in the loading script , I want to add a new column , if the product contain 'cat' ,and the order should be remark as 'cat order' . I wonder if I can use mapping load or left join. but I am not familiar with these 2 expression. Pls help me on it, thanks.
below is the target :
-
Concatenate two rows with overlapping data
Hi, How can I concatenate two rows that have overlapping data and only concatenate the unique data from both rows? For example the first row is 'QIBOT... Show MoreHi,
How can I concatenate two rows that have overlapping data and only concatenate the unique data from both rows?
For example the first row is
'QIBOTH-Q1D|QFRTF'
and second row is
'GPCQIBOTH-Q1D|QFRTF'
I want the final result to just be
'GPCQIBOTH-Q1D|QFRTF' as the second row already contains all the data from first row and just has 'GPC' as extra data.
-
Defect: Shaded areas on Qlik Sense Maps include internal area
Do you have any idea how we could go about resolving/investigating below? I’ve checked all I can within Qlik Sense and I can’t see a way of working th... Show MoreDo you have any idea how we could go about resolving/investigating below? I’ve checked all I can within Qlik Sense and I can’t see a way of working this. It might be a limitation of the map object (current patch, potentially future patch)
Otherwise, can you reach out to the vendor for help resolving an issue with Qlik Sense Map objects? Online research does not identified this as a known defect, resolved in a previous patch.
Problem: When an area defined by a KML is shaded, different areas fully enclosed are shaded as well.
Testing: Same behaviour regardless of KML file, level of thinning, region selected, app used and environment used. If any area is full surrounded by multiple selected area this does not occur, it only occurs when a single area fully encloses an interior area or area(s).
Example: Eden-Monaro is the selected area, and thus coloured green. ACT is not in the selection yet is also coloured green (Should be transparent, revealing the yellow layer below).
Object: Map, Area Layer
Version: Qlik Sense November 2024 Patch 10 - qliksenseserver:14.212.17
The problem is there since Qlik Sense Enterprise November 2021 Patch 12 -
Inquiry on Retaining Existing DB Passwords When Importing Tasks in Qlik Replicat...
Dear Qlik Support Team, We are currently planning to migrate Qlik Replicate tasks to another environment, such as UAT. During this process, we would l... Show MoreDear Qlik Support Team,
We are currently planning to migrate Qlik Replicate tasks to another environment, such as UAT. During this process, we would like to confirm whether it is possible to retain the existing database connection passwords that are already configured in the UAT environment when importing tasks from another environment (e.g., DEV or SIT).
Specifically, we want to avoid overwriting the UAT database connection passwords with those from the exported task file.
Is there an option or best practice in Qlik Replicate to preserve the existing DB passwords in the destination environment during the import process?Your guidance on this would be greatly appreciated.
-
Installed certificates are valid to connect to Qlik Sense
Hi All,I need some assistance with setting up Qliksense certificates in NPrinting. I have so far managed to to have everything working but cannot seem... Show MoreHi All,
I need some assistance with setting up Qliksense certificates in NPrinting. I have so far managed to to have everything working but cannot seem to understand why I keep getting an error for valid certificates. I followed all required steps from exporting certificates from QS using an admin user account to placing them into the required folder in NPrinting server but I still get the error.
I followed the below links:
What could I be missing here?