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.
Hi, we deployed a multi node installation and noticed a strange behave when changing security rules on QMC.
Some of the nodes are affected immediately when a security rule is changed, but other take minutes or hours to sync the new security rule. This happens often on the central node.
We tried several things, including increasing the number of max connections on postgress, but the only thing take seems to work is restarting the machine services. Have anyone got this error already? Thanks in advance.
Hi all,
I'm using Qlik Sense June 2019 edition.
I've been requested to try enlarging the table font size in a certain app, I'm using a table chart,
the one that comes with Qlik(Not an extension).
Seems like there is no option of adjusting the table text font size over the June 19 edition.
I would like to know if there is a hidden option of font size adjustment for the table chart (Pretty sure there isn't) or if there is an extension that acts as a table and have the setting of font adjustment.
Another option that was offered to me use to use "Sense Theme", I've tried to use it to adjust the font size but it's not applying to the table chart, also seems like there is no option to apply changes over the table chart(Screenshot attached).
Any suggestions?
Thanks.
Hi All
My client has asked me to remove the slash from the zero's
What I found is most of the Apps follow this format. But a few don't. I though it would eb one of the initial SET Statement, But when I copied and pasted the SET statements from the non slash zero App to the slash zero App it make no difference
And help will be appreciated
Thanks Robert
Slash
No slash
Hi, I am quite new to Qlik sense.
I would like to join my two tables in following.
Table-1
Table -2
Final Table
I would like to have as Final table as they will not be in different rows if Product Name is Same.
Can anyone assist?
Thanks in advanced.
Hi,
Can anyone help me with following if load statement. My files got different column names. So what I want to do is after certain date, I want load different column name. My codes is as follows:
if(Date(right(FileBaseName(),8))<Date('20210405'),
"Wishlist Visitor","Wishlist Visitors") as "Wishlist Visitor",
The spelling of column name is different for the files that is before that specific date. That codes seems no work.
Can anyone help?
Thanks in advanced
What's the point of using set analysis since it accepts only Data Model Fields and not Dimensions .
1. I see that almost every case where we need set analysis, it can be replaced by a combination of other functions like aggr(), if() etc. So do we really require set analysis?
2. I have a date field in my data model called "order_date" and dimensions "order_year", "order_week" which are derived from "order_date" field using formula Year(order_date) and Week(order_date) . I can't use these two dimensions in my set expressions. For eg, I can't use these dimensions like this
=Sum({<order_year={"<=$(=vMaxYear)"}>}Sales)
because "order_year" being a dimension can't be used and this formula will throw an error. So how do you handle situations like these and does Set analysis even help when I have my Calendar fields as Dimensions? If so, in what cases?
Thanks in Advance
@Henric_Cronström @sunny_talwar @swuehl
there are 2000 properties in 10 different countries. Each property has a purchase price.
there are 5 appraisers. Each of them reassess some of the 20 properties.
This leads us to two tables.
1: property, country, purchase price, date of sale announcement, status of sale
2: appraiser, property, estimated price
Table one shows property, country, purchase price overruled by estimated price of selected appraiser if exists (called "current price")
IF(
ISNULL(ONLY([estimated price by appraiser]))
,ONLY($(setexpression) [purchase price])
,ONLY([estimated price by appraiser])
)
where $(setexpression) restricts to specific timeframe when sales have been announced first as well as to specific status of sale
wanted: table two should show the sum of current prices per country (formula above aggregated by country) restricted to properties that fit to $(setexpression) in general
Hi All,
I need help with section acesss.
In the below table has the sample data where i want to apply Section access User level, but with some condtions.
Dep, ID, user
123 1 AAA
123, 2, BBB
123, 3, CCC
456, 4, DDD
456, 5, EEE
456, 6, FFF
User BBB and CCC reports to AAA - So AAA should see data for himself and also for BBB and CCC only.
Where BBB and CCC should see only their data
Same way, User EEE and FFF reports to DDD- So DDD should see data for himself and also for EEE and FFF only.
Where EEE and FFF should see only their data.
Please help me.
Thanks in Advance
Hello,
I have a simple timeseries data representing a sales event log. I would like to create a new column in script editor that classifies the given Ops id as WON, LOST or PENDING based on the below conditions:
IF for a given Ops id a "Deal signed" milestone exists, the new column (status) should return WON for all of the Ops id records
IF for a given Ops id a "Opportunity cancelled" milestone exists, the new column should return LOST for all of the Ops id records
IF none of the above, then new column sould return PENDING
Excel example attached, will appreciate any advice
Hi,
I am new to Qlik sense and need a little bit of help.
I need to insert a static target based off of the average number of customers from a financial year over 52 weeks. I believe I need to count the total amount of customers id's first, then sum them, then divide it by 52 weeks to get the average.
So in excel terms it would be IF( Financial_Year ='2020/2021', Sum(count(Customer_ID)/52)," ")
I then would need to create and upper and lower target with a 5% variance each way
If have the first part created using set analysis: Count({ $<Financial_Year ={'2020/2021'}>}count(Customer_ID)
I have a calendar variable that breaks down our financial weeks that I am using to plot on the graph.
Open to all suggestions, and really appreciate the help.
Below is a graph of how I envisage it to look.
I am open to any suggestions and appreciate the help :).
Thanks,
Alex
MVP
22801MVP
8655Employee
8650MVP
8199MVP & Luminary
7990Employee
6509MVP & Luminary
5366MVP
5176MVP & Luminary
4402Employee
4113Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.
We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.
Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’
Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.