Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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!