After trying a long time, I came here for help. 

Within a table , I would like to retreive a reference from last month, given that the value of an other variable = 1 in the data. However I cannot create the correct formula to solve this issue in Qlik Sense. 

DelLateCarrier should be the value that is 1

Reference is the number I want to have/retreive in the table, when for that reference the Dellatecarrier is also 1 in the previous month. 

I have tried some of the below formula's and combinations / adjustments of those. Could someone help me out? 

if(month(AddMonths(Today(), -1))[#DelLateCarrier] = 1, Reference,)

----------------------------------------------------------------------------------------------------------------------------------

if(Match(valuelist(({$<Month={$(= Month(AddMonths(today(),-1)))},Year={$(=Year(AddMonths(today(),-1)))})),[#DelLateCarrier]), 1), Reference,)

----------------------------------------------------------------------------------------------------------------------------------

if(match({$<Month={$( = Month(AddMonths(today(),-1)))

----------------------------------------------------------------------------------------------------------------------------------
Count({$<Month={$(= Month(AddMonths(today(),-1)))},Year={$(=Year(AddMonths(today(),-1)))},[#DelLateCarrier]={1}>}DISTINCT([Reference]))

----------------------------------------------------------------------------------------------------------------------------------

if(match([#DelLateCarrier] month(Today(), -1),1),Reference,)

----------------------------------------------------------------------------------------------------------------------------------

Hello Everyone,

In the chart legend, the long text is not showing complete text. If I hover the mouse, then it shows the full text. I have attached the screenshot for reference.
Can we adjust the legend size or any other way to show the complete text in the chart legend?

Thanks.

Hi Community,

 Qlik NPrinting 

I want to Install Qlik NPrinting On-Demand add for a client which infrastracture is the following

NPrinting Installed in a Server

Second Server S, with QMC  and QlikView  April 2019 SR1

Services in  this server:

• QlikView Directory Service COnector
• QlikView Distribution Service
• QlikView Management Service
• Qlik Service Dispatcher

Third server  with Access Point and QlikView  April 2019 SR1

Services in this server:

• QlikView Server
• Qlikview WebServer

Should I Install On-demand add in  second ant third server right?

Thank you.

Is there any plans to add Qlik Application Automation to Qlik Sense Enterprise for a cloud or on-premises solution? Or will it only available in SaaS?

Hi,

I've created a managed space but I don't see it when trying to define a destination.

I can see other managed spaces that I created previously.

Any idea why?

Thanks!

Hi everyone,

I would like to know your ideas on how to create an app level security with the fastest security rule evaluation.

Some points about the environment : 

• OEM client with :
  • >100 end customers (groups of around 5 to 20 users)
  • >100 streams : most of them specific for some customers, a few that can be shared across customers
  • >1000 apps
  • >1000 users 

• If we were doing some app level security with custom properties, we would have >1000 custom properties values
  • by user
  • or
  • by app
    which is totally out of the Qlik recommmandations
    
    
• Is there another way ?
• Are >1000 Active Directory Groups faster to evaluate than >1000 custom properties values ?

In general, how do you deal with large volume of users/apps and still have a good performance of rules evaluation ?

• I may have an idea of how I am going to implement this but I want your fresh ideas first 🙂

Thanks for your ideas !

Regards,

Thomas

I need a user who can have an access to QMC and have an ability to reload created task. 
But whatever I do even when I have start reload task button I cannot trigger it. There is an issue:
"The operation failed due to insufficient privileges."
And I have no Idea what kind of permissions I have missed?

P.S. I have noticed that I can trigger task if give user access to update the application. But the idea is that user can see configuration and trigger task. User should not have the permissions to update/delete/create anything.

Bom dia, pessoal

Possuo dados dos clientes mês a mês, com a idade e a faixa etária desse cliente naquele mês. Por exemplo, em 01/2020 o cliente X estava na faixa 031 035 e em 04/2021 ele está na faixa 036 040.

Quando eu busco esse cliente por um ano/mês específico, a informação aparece apenas uma vez de forma correta, porém se eu busco o mesmo cliente em um período maior, ele aparece 2 vezes.

Gostaria de uma forma que o Qlik considerasse sempre a MAIOR faixa de idade no período selecionado. No caso do gráfico apareceria apenas 036 040.

Alguém sabe como eu conseguiria resolver isso?

Obrigado

Hi 

we have many user complaints each monday morning  when user consult Published reports ,

We are in QV 12.4  

Have idea to avoid theses problems ?

we have a QVS physicaly server (2 T memory ) an other server (Publisher server ) and in last a VM where IIS components is installed ,

Could we have some configurations parameter betweenn servers QVS end IIS Server

Have you another idea to manage  users ,

Manys users exports in excel whit big  data volume from access point

How you can identify botleneck ?with what tools

Do you recommend to purge shared file objcets on qvw application

Have you other idea  ?

Thanks

Regards