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 Purchase Order Number])={'*TQBH*'},[Order Type Code]={'ZSTD','ZTTB'},[Fact_Type]={'FACT_ORDER'}>}
distinct [Order Document Number]
)

  why and pls help me check it .

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 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.

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 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

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 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

HI, 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 :

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 

'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. 

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 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

Dear 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.

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 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:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/NPrinting-with-Sense.htm#InstallingQlikSenseCert

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Troubleshooting/NP-wont-read-QS-certificates.htm

What could I be missing here?

Qlik NPrinting Qlik Sense Business