Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Is there any way that a button can change color it's selected? I have a button that is matched with a favorite and I want for the user to see that the button has been selected instead of looking in the filters. Does this exists?
For instance, I have the white button here that is not selected but when it does, it has to become grey.
I am running out of ideas as to why this URL request is throwing the 415 error. We have Talend Data Catalog and I am requesting the endpoint to logout the authentication that is currently logged in. I tested this request using the Data Catalog API tool and it was successful. I have the same setup as shown in the web tool in Studio, but I cannot figure out the problem. Can someone please help me? The attached document shows the request and 200 response log from the Data Catalog web tool along with the Studio request and 415 response log. Am I missing something?
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.
Hello,
I have a dimension called ''Exercice période'' in French which mean Period exercice. I want to systematically select the previous month of the period in a favorite that I will create, as an example, we're in May, I want to select April.
Any expression for that please?
Hi,
I have a main table which has customers for each day for a period of 2 years.
Example
Date | Customer |
1-Jan-24 | Customer1 |
1-Jan-24 | Customer2 |
1-Jan-24 | Customer1 |
2-Jan-24 | Customer1 |
2-Jan-24 | Customer3 |
2-Jan-24 | Customer2 |
3-Jan-24 | Customer2 |
3-Jan-24 | Customer4 |
3-Jan-24 | Customer4 |
A distinct count of customers over each day gives me the below table
Date | count(distinct Customer) |
1-Jan-24 | 2 |
2-Jan-24 | 3 |
3-Jan-24 | 2 |
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.
=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.
count(TOTAL DISTINCT{<Date={">=$(=date(max(Date)-30))<=$(=max(Date))"}>} Customer)
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.
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
Am new to qliksense. Using Datamanager Table edit am trying to add a new calc field. In that field am trying to write an expression with IF condition like
IF(Income>8000 and Income<=30000,1,0)
Getting an error missing right parenthesis. Can we use IF with And inside calculated field in Data manager ?
Kindly help
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"
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!