Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way that a button can change color it's selected? I have a button that is matched with a favorite and I want for the user to see that the button has been selected instead of looking in the filters. Does this exists?
For instance, I have the white button here that is not selected but when it does, it has to become grey.
Hi ,
Could someone help me rectify the error in following script(Attached screenshot).
Getting error 'ValueCategoryGlobal' and 'ProcessTypeGlobal' not found. Though these fields are present in residents tables Valuecategory and ProcessType respectively.
I am expecting Fields Value, ValueCategoryGlobal and ProcessTypeGlobal in temp table. But only field coming is Value.
Hi
I'm facing problems to connect the excel complement to the spreadsheets.
I used to do the login but the account was not with the plan to use this complement, so our account manager gave us a tria. Since then I can not reach the login
Attached you wil find images that the excel complement it is not turn on in the managment console and the response of our account manager (Alexis Whittaker - Alexis.Whittaker@qlik.com)
G'day,
It is normal for the new Trial Unlock file for Qlik Sense Desktop to come out before or after it expires? Needing to refresh my memory on dashboard creation for the upcoming Qlik Connect conference in Orlando so I can get certified. Thank you!
I need to modify an existing P&L table with several scenarios (using the Vizlib solution with external Excel table).
Is it possible in a P&L table to use different factors per line?
sum( Value* $(=PL_View_Factor_Best) )
I get the right calculation, when the factor is the same for all lines, but when using different values or even a conditional value for different scenarios, it returns no value.
Is there another/better way to solve this?
I need a cumulative count of the following data:
Reason/Yearweek | 2024/01 | 2024/02 | 2024/03 | 2024/04 | 2024/05 |
ABC | 1 | 5 | 2 | 1 | |
DEF | 1 | 3 | 2 | ||
GHI | 1 | 2 |
at the moment I've created a field called 'Count' populated with '1' in the data load and attempted a range sum
Rangesum(Before(Sum(Count),0,ColumnNo()))
which produces the following
Reason/Yearweek | 2024/01 | 2024/02 | 2024/03 | 2024/04 | 2024/05 |
ABC | 1 | 6 | - | 8 | 9 |
DEF | 1 | 4 | - |
6 |
|
GHI | 1 | - | - | 3 | - |
I want it to show like this :
Reason/Yearweek | 2024/01 | 2024/02 | 2024/03 | 2024/04 | 2024/05 |
ABC | 1 | 6 | 6 | 8 | 9 |
DEF | 1 | 4 | 4 |
6 |
|
GHI | 1 | 1 | 1 | 3 | 3 |
Is there a way to do this - either with the formula I have or an alternative approach?
Hello,
we are about to use IAC in our apps on Qlik Client Managed env, but we cannot see any possibility to monitor the usage of Insight Advisor. Here is an example of metrics:
I did not find any API endpoint for Client managed solution either.
Thank you for all comments!
Hi,
Can you kindly help me understand how to apply distinct count for the following expressions,
count(distinct{<[Price check]={"=If((sum([Dealer Sell-in price])-[Unit Price (EUR)])>0,'N','Y')"}>}[Part Number])
In the above expression, , Unit Price = sum(Price * Exchange
)/sum(Quantity), Price check=If((sum([Dealer Sell-in price])-([Unit Price (EUR)]))>0,'N','Y'))
Currently, the formula is making distinct count on all the part number but I need it distinct count only the [Part Number] with [Price check] is 'Y' for each Dealer.
Let me know if you need any other details from me.
Thanks in advance
I searched far and wide but found nothing. I know how most people feel about Qlik, but what about using it for embedded analytics? I'm interested in:
- how easy it is to embed (into an app, I need a real-time dashboard)
- what the UX is like for the end-user - does it load quickly, play well with the rest of the app, glitch out, etc.
- how much it costs and how it's priced (consumption-based per query, flat fee, etc.)
- how it compares to similar embedded intelligence apps, e.g. ThoughtSpot
Thanks a bunch!
I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD's in my data and simply adding them to my chart in Excel but in Qlik, I can't seem to work this out.
Below is how I would have it created in Excel:
This makes an easy year on year comparison possible.
But how can I get ytd's and add them to a grouped bar chart like above AND have these refreshed automatically upon a new data load?
I' ve been puzzling with expressions for dimensions in the chart but that didn't work out, I tried to add a variable containing the YTD (add wanting to add YTD-1 and YTD-2 later on).
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!