Hello,

Can anyone please help me with below. I have a data 

Country       Product        User
USA            Electronics    123
USA            Electronics    123
USA           Electronics    123
USA           TV                 123
USA           TV                 134
USA           Laptop           156
CANADA    Electronics     456
CANADA     Electronics     567
CANADA      Electronics    765
CANADA     TV                  456
CANADA     TV                  567
CANADA     Watch            765

When USA is selected

Product      Count of Users
Electronics         3
TV                      2
Laptop                 1
Ipad                     0
Smart Phone       0
Watch                    0

When CANADA is selected

Product         Count of Users
Electronics              0
TV                           2
Laptop                     0
Ipad                         0
Smart Phone            0
Watch                       1

The Product column should always show all the Products regardless on selection and should display 0 if there are no products for the given selection.

Thanks in Advance

Hi All,

We have NPrinting task on Qlik Sense QMC once Qlik job getting done then NPrinting task trigger automatically.

This thing earlier we used to do using window NTLM authentication by using service account user id and password. But in new organization we don't have permission to enter service password manually. So I looking how to authenticate using certificate or some other way for GET and POST method.?

In dev we have permission to enter manual password. We checked it working but UAT we don't have permission. I would to request please help on this to achieve. 

Thank you in advance.

Thanks & Regards,

Irshad Ahmad

Hello all,

Any help or advice would mean the world!!

I created a Qlik app in Qlik Sense Enterprise and was able to create a REST API POST connection that triggers a Databricks job(the REST connection uses an access token i created from Databricks) to run with dynamic selections made by the user. Databricks performs some transformations on the data with the parameters sent from Qlik and I then utilize an Apache Spark Connector to read the data back into the app. 

Current methodology: I as the developer can open the app that has a default dataset already loaded. I then make some selections in a couple of filters and click a button called "Load Data". This button sets my selections as variables first and then finally, performs a Load Data action that initiates the REST API call (first action in the qlik load editor) to send my inputs to Databricks and then loads the transformed data back with an apache spark connector(which i also have to give users access to).

The Problem: I can obviously do this myself since I have access to Databricks and it is my REST API connection, but I need make sure users(there will be potentially hundreds) that are using this dashboard will have a seamless way of sending their own inputs through the REST API post method. Is there a way I can somehow change my current configuration so any user with access to the dashboard can utilize its connections? Or anything else?

I have attached my current configuration of my REST API Connector for context:

Is it true that the Variable input object is only active with the value applied for the duration of the session for that user? Is there no way to use this object to set a persistent configurable value?

For instance, I wanted to use variables to adjust the segments of a gauge so that a manager could use the Variable input to set the desired value for the app, impacting all users of that app.

I can't be the only person to want to use Variable input in this manner. 

Hello,

I am working with QV version 12.

To give you some context, I have 16 tables that are essentially the same but correspond to different years. I need to filter by a specific record, such as an 'id'. Each table contains between 6 and 12 million records, so loading all the records and then filt

Boa tarde, caros colegas.

Gostaria de uma ajuda, se possível. Tenho uma situação onde preciso fazer o cálculo do custo proporcional de cada produto de acordo com a sua quantidade, conforme demonstrado abaixo. Quando eu tenho um único produto de uma mesma conta e centro de custo, o Custo Proporcional deve ser igual ao campo Valor. Quando eu tenho mais do que um produto para a mesma conta e centro de custo, eu preciso somar as quantidades do campo Qtde Total dos itens, dividir a quantidade de cada produto pelo total e multiplicar pelo Valor para achar o custo proporcional. Usando o Excel, consigo fazer um somases e informar como parâmetro o valor da conta e do centro de custo na própria linha, mas no Qlik não estou conseguindo fazer isso. Alguém tem alguma ideia de como fazer, por gentileza?