I am trying to do section access for only a specific user but all other users with access to the app I would like to grant full access. Is there a simple way of doing this without managing users in two places?

I have a load script that had dash or -. I want to exclude them from the load script. I know I can do it within the app, but I like to do it on the load script.

Len(Trim(Category))=’-‘ works, but I need the opposite     Len(Trim(Category))<>'-' The opposite does not work.

Any help will be great.

Hi all,

I started to develop an extension for graph visualization based on the Graph Dracula Library, using Raphael: http://www.graphdracula.net

This seems to be an interesting topic. First of all, what is the best data representation of graph data in a relational QlikView world? Second, there are a lot of limitations using those JavaScript libs. I've tried some before (D3.js etc.) but Dracula seems to have the simplest interface for my use case.

What is your opinion?

- Ralf

Hi,

I have a main table which has customers for each day for a period of 2 years. 

Example

A distinct count of customers over each day gives me the below table

Now, I have to calculate the distinct count of customers for each date over a rolling past 30-day window. 

For example, on 1-Feb-24, I need the distinct count of customers from 1-Jan-24 to 1-Feb-24. On 2-Feb-24, I need the distinct count of customers from 2-Jan-24 to 2-Feb-24. I have tried the below methods so far.

• Using the Rangesum with below function, but it aggregates the distinct count of Customers each day and sums it up over the rolling period.

=rangesum(below(aggr(count(distinct Customer),Date),0,30))

The problem with this is there will be duplicates across the 30 day period and the above formula adds them all up. 

• Hard code the dates like below but it takes the overall table's max date so the count is common across dates.

count(TOTAL DISTINCT{<Date={">=$(=date(max(Date)-30))<=$(=max(Date))"}>} Customer)

• Rangecount doesn't seem to work either. It returns '30' for all dates.

rangecount(below(aggr(count(distinct Customer),date),0,30))

I would really appreciate any help that would help solve this issue.

Thank you very much.

Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024

A EXPRESSÃO QUE ESTOU USANDO É: 

( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)

ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
 

Hello, I am trying to setup a Generic LDAP UDC to our Google Workspace domain using the Google LDAP server. The setup process seems to fail because of a timeout but I can connect and browse through the LDAP server using Softerra LDAP Administrator. The certificate from Google is installed in my user's certificate store, the service user's certificate store, and in the local machine certificate store. The firewall is disabled. Running on Windows Server 2022.

From the Repository\Trace\UserManagement_Repository log:
"Fetching directoryentry LDAP://ldap.google.com:636 failed: This operation returned because the timeout period expired.
Setting up UDC of type Repository.UserDirectoryConnectors.LDAP.GenericLDAP unsuccessful Setting up connection to LDAP root node failed. Check log file."

From the Proxy\Trace\System_Proxy log:
"Failed to authenticate stream as Server An unknown error occurred while processing the certificate↵↓A call to SSPI failed, see inner exception. NO-STACKTRACE
Above happened because: An unknown error occurred while processing the certificate NO-STACKTRACE
Unanticipated System.Security.Authentication.AuthenticationException occurred accepting client, disposing connection attempt"

Hi,

I have migrated a .nsq file from NP-v16 to the Qlik Nprinting 2021 and changes to reports.

Now i want to import only one specific Report from .nsq zip file to overwrite the recent changes.

When i clicked on Import NP 16 Report(as in below screenshot), it shows all the other report except the report I want to replace. 

Any suggestions, please.

how to read pdf file which contain text, graph and tables also but i want only load table data into database, what should i do? which custom component used?

I have a table that I need to filter based on multiple columns.  The scenario is that I need to look up a worker's name and filter the table if the worker's name shows up in ANY of the columns below:

Worker

Level 1 Manager

Level 2 Manager 

Level 3 Manager

Level 4 Manager

I need to show the entire supervisory org based on the selected worker.  Thank you for any assistance you can provide.