Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
We have QlikSense on prem; at the authentication level, we would like to connect a website where users authenticate using Office365 accounts, to the QlikSense application.
I'll try to explain our need: we have a website; users authenticate with their Office365 accounts. They exists also on QlikSense in the users list because the list is automatically updated every day. I want that when a user log in into the website, he is authenticated also on QlikSense.
How can I accomplish this?
I tried to explore the solutions in the documentation, bot got lost.
Thank you
Hi Experts
Please help with real-world experience using QVX files kindly share some insights into their use cases?
Additionally, if there are any relevant documentation or resources available on this topic, I'd greatly appreciate it if you could share them as well.
Thank you!
I have a Pivot Table with two dimensions the PLACE in the Y Axis and The Week on the X Axis.
The Function is like Sum ({<Place, Week>} Weight)
I colored the background of each Name of The dimension PLACE with a different color and with the Function:
Pick(Match(Place,'A','B','C'), red, green, yellow )
Why when i Select a value in the pivottable the colors disappear?
Hi all,
i'm trying to login to qlik using a JWT token but when i try to post to https://horsadev.eu.qlikcloud.com/login/jwt-session with the the web integration id and the bearer token i get the following error.
the token is made up like this:
user details: name sub and email are the exactly like the console.
any idea of what can go wrong here?
thanks,
Loris
Hi everyone,
At the moment, I am working with a PDF report with Qlik Reporting, and I would like to add Vizlib visualizations. Does anyone know if, just like with NPrinting, Vizlib work with reporting?
I look forward to hearing from you!
Thanks a lot
Bonjour,
Où trouve-ton la tâche planifiée de chargement de données de qlikview (version 12) ainsi que les informations associée horaire, fréquence déclenchement ... comme on le voit sur QMC de Qliksense ?
En vérifiant l'ensemble des tâches planifiées sous Windows, nous ne voyons pas de tâche planifiée portant de nom significative qui pourrait être associée à l'application qlikview.
On ne trouve pas assez de détail dans la documentation Qlikview.
Merci par avance.
Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.
Thank you.
Family | Quarter | Qty | RollingSum3 | Family,Quarter,Qty |
A | FY2023Q2 | 10 | 10 | A,FY2023Q2,10 |
A | FY2023Q3 | 20 | 30 | A,FY2023Q3,20 |
A | FY2023Q4 | 30 | 60 | A,FY2023Q4,30 |
A | FY2024Q1 | 40 | 90 | A,FY2024Q1,40 |
A | FY2024Q2 | 50 | 120 | A,FY2024Q2,50 |
A | FY2024Q3 | 60 | 150 | A,FY2024Q3,60 |
A | FY2024Q4 | 70 | 180 | A,FY2024Q4,70 |
B | FY2023Q2 | 5 | 5 | B,FY2023Q2,5 |
B | FY2023Q3 | 10 | 15 | B,FY2023Q3,10 |
B | FY2023Q4 | 15 | 30 | B,FY2023Q4,15 |
B | FY2024Q1 | 20 | 45 | B,FY2024Q1,20 |
B | FY2024Q2 | 25 | 60 | B,FY2024Q2,25 |
B | FY2024Q3 | 30 | 75 | B,FY2024Q3,30 |
B | FY2024Q4 | 35 | 90 | B,FY2024Q4,35 |
I have dataset like this
TranID | Line nr | itemCode | LineType |
123 | 1 | Gitem1 | group |
123 | 2 | item12 | inv |
123 | 3 | item34 | inv |
123 | 4 | - | endgroup |
123 | 5 | Gitem2 | group |
123 | 6 | item55 | inv |
123 | 7 | item6 | inv |
123 | 8 | item5 | inv |
123 | 9 | - | endgroup |
1235 | 1 | Gitem12 | group |
1235 | 2 | item12 | inv |
1235 | 3 | item34 | inv |
1235 | 4 | item76 | inv |
1235 | 5 | - | endgroup |
1245 | 1 | Gitem17 | group |
1245 | 2 | item6 | inv |
1245 | 3 | item8 |
inv |
and I want a new field ItemGroup where is the group item of each line that it belongs too.
So I basically want to add the itemcode (example Gitem1) of the LineType "group" to new field ItemGroup
to all the fields with the same TranID as long as LineType "endgroup" is reached. After that the next group's itemCode is added to the next lines to ItemGroup -field
TranID | Line nr | itemCode | LineType | ItemGroup |
123 | 1 | Gitem1 | group | Gitem1 |
123 | 2 | item12 | inv | Gitem1 |
123 | 3 | item34 | inv | Gitem1 |
123 | 4 | - | endgroup | Gitem1 |
123 | 5 | Gitem2 | group | Gitem2 |
123 | 6 | item55 | inv | Gitem2 |
123 | 7 | item6 | inv | Gitem2 |
123 | 8 | item5 | inv | Gitem2 |
123 | 9 | - | endgroup | Gitem2 |
1235 | 1 | Gitem12 | group | Gitem12 |
1235 | 2 | item12 | inv | Gitem12 |
1235 | 3 | item34 | inv | Gitem12 |
1235 | 4 | item76 | inv | Gitem12 |
1235 | 5 | - | endgroup | Gitem12 |
1245 | 1 | Gitem17 | group | Gitem17 |
1245 | 2 | item6 | inv | Gitem17 |
1245 | 3 | item8 | inv | Gitem17 |
Hi Team,
I have developed an UI that is using highchart for graphs and getting data through hypercubes.
Everything is working fine except data filters that is getting passed from UI.
I have 10+ filters and except date filters everything working as expected.
Can any expert help me out here:
Code:
------------------------------------------------------------------------------------------
async onSelectSingleDate(date){
const myDate = moment(date).format("YYYY-MM-DD");
console.log('myDate', myDate);
//create the expression - the result from this expression gets the values that are between the selected dates
const dateExpression = `=Concat({<[Bookings Date]={"${myDate}"}>} distinct [Bookings Date],',')`
console.log('dateExpression', dateExpression);
//evaluate expression to get the selected dates
const expressionResult = await this.qlikService.evaluateExpression(dateExpression);
console.log('expressionResult', expressionResult);
// collect the values to select
const selectedValues = [{qText: expressionResult, qIsNumeric: true, qNumber: new QSDate(moment(expressionResult)).getIntegerValue() }];
console.log('selectedValues', selectedValues);
//apply values
await this.qlikService.selectMultipleValuesPerField('Bookings Date', selectedValues);
//refresh data
await this.refreshData();
}
Hi,
A customer of mine is requesting automated Excel reporting to Dropbox according to a particular template. However, I cannot seem to find a solution.
The customer wants a Excel report based on a table in the dashboard. Some changes need to be made, that we cannot include in the table in the dashboard. Therefore, we need a template in Excel, like in Tabular reporting. However, then we cannot distribute the report to a Dropbox folder. Due to the fact that we need to use Excel, application automation is not possible.
Does anyone know how to achieve this?
kind regards,
Sterre
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!