Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hello i'm trying to create a field which will "predict" shop monthly revenue based on current average revenue. In other words im taking revenue from current month and divide it by days that have already passed. Then im multiplying this number by number of days that there are in month.
So it look like this :
((Sum({<[channel]={'ABC'},Yearx={'2022'},[Monthx]={'May'}>} [Revenue]))/(day(today())-1))*31
So as you can see i have put manually year, month and number of days in a month. i would like to automate this so i won't have to change it every month 🙂
But i cant figure it out
I've tried with [Monthx]=month(today()) but it doesnt work...
Hi: Has anyone figured out how to integrate DUO, which is SAML standard, to Qliksense SAAS, as IDP/SSO?
Or is it just impossible because QS only support OIDP standard ?
We have DUO already and don't want to adopt something else unless we absolutely have to
thanks for any info,
Don
Hello community
I'm facing an issue about add many measures on the radar chart (bundle vizualisation)
we can only put 1 measure...
we cannot realise the same viz like qlikview ( in order to show benchmark for example)
Is there a tips in order to realize real Radar Chart?
Tanka a lot
Within Qlik Sense Hub, I am trying to create a YYYYMM table to link to several other tables. However, I cannot seem to get the data types to align between tables so when I try to connect on this field, the connection seems poor. Both fields are coming from imported excel files and I have reviewed the fields in each file several times to ensure they are the same within the underlying excel. I don't understand why Qlik left justifies one column but right justifies the other column (see screenshot).
Any help on how to get these fields to align with each other is greatly appreciated.
Hi team,
I would like to get the field "Cumulative cost"
year | contract | code claim | cost | Cumulative cost |
1 | a | 1 | 10,00 € | 10,00 € |
1 | a | 2 | 20,00 € | 30,00 € |
2 | a | 3 | 5,00 € | 5,00 € |
2 | a | 4 | 30,00 € | 35,00 € |
3 | b | 5 | 40,00 € | 40,00 € |
3 | b | 6 | 5,00 € | 45,00 € |
3 | b | 7 | 5,00 € | 50,00 € |
Do you have some idea? I would like to have it inside of the script.
Thank you very much,
Hello!
I import data in te following form:
Apartment ID | AIR CONDITIONING | HEATING | BALCONY | PARKING |
255 | YES | NO | NO | NO |
301 | NO | YES | NO | YES |
075 | NO | NO | NO | NO |
111 | YES | YES | NO | NO |
023 | YES | YES | YES | YES |
I would like to create a chart/table as the following:
YES | NO | |
AIR CONDITIONING | =count({<AirCond={YES}>},AirCond)=3 | =count({<AirCond={NO}>},AirCond)=2 |
HEATING | =count({<Heating={YES}>},Heating)=3 | =count({<Heating={NO}>},Heating)=2 |
BALCONY | =count({<Balcony={YES}>},Balcony)=1 | =count({<Balcony={NO}>},Balcony)=4 |
PARKING | =count({<Parking={YES}>},Parking)=2 | =count({<Parking={NO}>},Parking)=3 |
Any idea of how I could do this?
I have a problem creating a Set function for accumulating all valaues up to the selected filter (Year, Month, Date).
My aim is to SUM all values and display them in a bar char (drill down year, month, date).
The values should be summed up to the max selection.
For example: if year 2022 is selected, all values before 31.12.2022 summed up.
ID | Year | Month | Date | Value |
1 |
2022 | 02 | 01.02.2022 | 50 |
2 | 2022 | 01 | 01.01.2022 | 50 |
3 | 2021 | 12 | 01.12.2021 | 50 |
4 | 2021 | 11 | 01.11.2021 | 50 |
5 | ||||
Hello!
I want to get a table chart in which I will see the following: partner, keyword, number of customers, percentile (which percentile corresponds to the number of customers for this keyword inside the partner in the row).
I understand that I need to use a fractile to calculate percentiles in qlik sense, but I have not yet managed to figure out how to get a fractile to express the number of customers within a partner group for my table.
partner | keyword | customers | perc (fractile) |
p1 | k11 | 10 | 0.40 |
p2 | k33 | 5 | 0.30 |
p2 | k22 | 20 | 0.85 |
Thanks in advance for any tips for this!
MVP
23033Employee
8883MVP
8724MVP
8295Partner
8001Employee
6556MVP & Luminary
5794MVP
5399MVP
4751Employee
4006Learn about what's new across all of the products in our growing Qlik product portfolio.
Important and useful support information about end-of-product support, new service releases, and general support topics.
All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Der deutsch(-sprachig)e Qlik-Markt bietet so manche Spezialität, die sich hier leichter diskutieren läßt.
Transform financial outcomes with next-gen business intelligence strategies
How Qlik helped Greene Tweed reduced time to insights by 65%
Attend a live webinar session with our expert instructors and special guests to review learning topics in the Qlik Continuous Classroom and beyond.