Hello community,

I'm having trouble adding incremental data into a QVD file named YH1.qvd. Here's the code I'm using:

TableYH1:
Load *
FROM [lib://DataFiles/YH2.qvd]
(qvd);

concatenate

LOAD
*
FROM [lib://DataFiles/YH1.qvd]
(qvd);

store TableYH1 into [lib://DataFiles/YH1.qvd] (QVD);

The issue is that I'm unable to change YH1.qvd. Can someone help me understand what's wrong?

Regards
Bhavya

Hi All,

I have created 100% Stacked bar chart with 2 dimensions and 1 measure

Dim: Div_code, Region

Exp: Sum(Value)/Sum( Total <Div_code>Value)

the chart is displaying as expected.

but the client want to have a 100% stacked bar chart with drilldown dimensions

Div_code and Branch_code (Drilldown dimensions)

once we click on Div_code on Stacked bar chart its should show Branch_Code details with 100% stacked bar

is it possible ? if yes can you suggest the process.

-Thanks

Eshwar

Does anyone have an example if its possible or how within Qlik SaaS cloud i can create a successful connection to a personal list in SharePoint.

the SharePoint Meta connector i can authenticate with the base URL no issue (https://somecompany-my.sharepoint.com) , but getting to the list is challenging.

below is the example URL:

https://somecompany-my.sharepoint.com/personal/someuser_com/Lists/listname.aspx

any advise would be appreciated , i have already swapped out the list name for the ID

I need to count the retourning customer:

A retourning customer is defined as:

Buy a product in the latest day of the Data base.

- They didn´t buy a product in the last 6 months

- They bought a product from 7 months to the beginning of the Data base.

I have this code but it doesn´t correct correctly:

count({<
Customer=e({<Transaction_date={'>=$(=Date(AddMonths(Max(Transaction_date), -6), 'DD/MM/YYYY'))<=$(=Date(Max(Transaction_date)-1, 'DD/MM/YYYY'))'}, Customer-={'*'}>}),
Transaction_date={"=Sum(Sales) > 0"},
Customer-={"=Sum({<Transaction_date={'>=$(=Date(AddMonths(Max(Transaction_date), -6), 'DD/MM/YYYY'))<=$(=Date(Min(Transaction_date)-1, 'DD/MM/YYYY'))'}>} TVLMSLD) = 0"}
>} DISTINCT Customer)

Thank you in advances

Hi

Looking for exporting to excel all variables  and their definitions in qlik sense (Ideally documentation all details of App like all variables, query or connections etc)

if anyone done so please give some help please and did explored the API and add on's but we got limitations using them and trying the Automation job now.

Hi there.

I have a problem and I can't seem to fix it in my load editor I want to import only the values of the latest row found for each Kenteken. So for instance a Kenteken xx-00-xx can be on row 12000 and the same one xx-00-xx can be on 14000. I only want to import the latest row with that particular kenteken and other fields in order to get rid off duplicates. I want it to be done in the load editor and not in the front-end.

Unfortunately I can't do anything with dates because they can be similar and there are too many variances.

This is the script:

Hi Team,

 I am trying to create chatbot in qliksense mashup using this tutorial. https://qlik.dev/embed/gen-ai/create-chatbot-nl-api/.  this tutorial uses this endpoint {qliksenseurl}/api/v1/questions/actions/ask to generate response either text or nebula js chart to show in chatbot. (https://help.qlik.com/en-US/sense-developer/February2024/Subsystems/NLBrokerAPI/Content/methods-post-questions-actions-ask.htm)

I was able to follow tutorial and able to create chatbot which return nebula bar chart as response when ask by user but when I try to customize it to add other chart. It doesnt work.

I even tried with POSTMAN and it gave same result. I was able to retrive nebula bar chart but not others.

this are details I sent to this url:

method: POST

url endpoint: https://qliksense url/api/v1/questions/actions/ask

headers: 

Hi everybody,

I have tried to sort the filter-values shown on the screenshot. Unfortunately they are sorted as Strings due to the concat-function i use for creating the "selections". Does anybody know how to sort the values correctly?

Buongiorno a tutti,

sto configurando un server SMTP in un ambiente Cloud, l'SMTP è Office 365 e ho notato che è stata inserita una nuova sezione dedicata per configurarlo. Ho inserito l'ID del tenant, ID Client e Segreto Client (ovviamente sono corretti, generati e copiati direttamente). Ho impostato anche le API permission per Microsoft Graph come indicato qui

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/mc-configure-email-support.htm

Quando salvo le impostazioni in Consolle mi viene mostrato l'errore "Credenziali Errate". 

Per completezza aggiungo che è presente anche una configurazione SMTP normale (fino a poco fa non era presente quella dedicata ad Office 365) che non era funzionante pur essendo configurata esattamente come altre in altri ambienti funzionanti.

Qualcuno può aiutarmi?

Grazie mille

Hi community,

I´m trying to bold only the rows headers in a pivot table, but the only thing I could find is Bold all the row- headers and values, using a CSS: .qv-object .qv-pt .cell{ font-weight: bold; }. 

Any ideas?

Tnx,

Tsion