Hello,

I have created dasboard in Qlik Sense. I created variables for my measures like example below. I want to use Nprinting based on user values, so I set an employee ID number value in variable  part of filter, then I added this filter for user but it does not work.  Any help will be really appreciated?

SET v_RESPONSIBLE = 'SEC_ACC_ADMA';
SET v_RESPONSIBLE_PS = 'SEC_ACC_PS';

SET v_OsUser = (upper(SubField(OSUser(),'=',-1);

Measure: count({<SEC_ACC_PS={$(v_OsUser)},TASK_ENTITY={"Proje Ziyareti"}>} [Task_Subject])

Nprinting :

Thanks.

I am replication from Oracle 11.2.0.4 to target MySQL 8.0.30

The source table has some default values. I would like to use global transformation to replicate default values to target table. When my source table has column "STATUS" default value='OPEN', the target DB status column should be having values 'OPEN' as well.

replace($name,'OPEN','OPEN')

I hit into error as attached screenshot.

My global transformation define as

Global rules --> new rule --> replace column values

Can help please as I am not familar with the function.

Thank you.
Desmond

Hi Qlik Peeps,

We would like to ask about this issue occurring now. One of our user had an analyzer license and  switch it to professional license but when she login her account it seems that the license still was the old license she have (analyzer license. Is there a quarantined happening on the account?  

We are currently using Qlik Sense Enterprise May 2022 version.

Any thoughts on this?

Thanks in advance.

I have 4 Sheets currently split through separate apps, these can be brought together to one if necessary. I am trying to present them on TV screens as dashboards to show work available etc. 

I can create an embeded link for the sheet which only I can view as it is a preview and this shows the format I want as storytelling removes the formatting and with F11 the default view still has the header like below.

  Is it possible and if so how can I go about presenting the a sheet or multiple sheets to a TV screen via a URL, etc. and have multiple sheets cycle through like a slide show while still looping back to the beginning once it has gone through all sheets? 

Dear

I have a order table which has sales district info , The below 'RC_PSS Simogear'  shows 0  in PY in the pivot chart. How to  create like it?

This is my pivot chart. It could not show the RC_PSS Simogear.  Should I use "Outer Join"?  Use Order table outer join Master Calendar table? or is there any other method?  I am really appreciated for your reply.

Hi All,

autonumber with qlik partial load giving wrong results.

can you please suggest how to go ahead for the same.

is there any alternative functions that we can use for the partial load.

thanks

Hi 

I'm trying to figure out how to create a table with all required columns in qlik sense from a sql dbo.

This is what comes from the SQL report builder and pumped out:

The finance department want a 'like for like' App within Qlik Sense - as close to replicating the above format as posssible.

However, I'm relatively new to Qlik and just can't seem to make it happen.

The image below is a snapshot of what the App is looking like as I test dimensions and measures.:

But I just can't seem to achieve the right formatting to get 'Categories ' across the top.

I would be enormously grateful for any input and help.

Thank you

Chris