Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I want to assign a specific color for each category of [Agent supergroup] in my drilldown master item, much like asked here.
I figured that I could color my graph by expression, with an expression (or, as suggested, an expression stored as a second master item) starting like this
=If(GetSelectedCount([Agent supergroup])<>1,
Pick(Match([Agent supergroup], 'Hospitals', 'Private laboratories', 'Private practices', 'Other'), '#006580', '#C8C7A9', '#AC4D58', '#99CFCD'), ...)
Without further colors instead of the '...', all subcategories will be colored gray. I guess that I could add more Ifs for [Agent group] and [Agent], but since
I just want to assign [Agent group] a color by its position in the list of possible values:
Concat({$<[Agent group]=>} DISTINCT [Agent group], ',')
So I constructed an expression around this to get a color number between 1 and 12 and then added Pick() as follows:
If(GetSelectedCount([Agent group])<>1,
Pick(Mod(Len(KeepChar(Left(Concat({$<[Agent group]=>} DISTINCT [Agent group], ','), Index(Concat({$<[Agent group]=>} DISTINCT [Agent group], ','), [Agent group])-1), ',')), 12)+1,
'#006580', '#C8C7A9', '#AC4D58', '#99CFCD', '#E1DAD5', '#83AF9B', '#E0BD8D', '#8A85C6', '#10CFC9', '#A16090', '#87205D', '#C4CFDA'), ... )
(These are the 12 default Qlik Sense colors.)
My test-KPI shows the correct color number, but the categories of [Agent group] in the graph are still one and the same color.
Do you have a hint?
Hello,
We have a Full load + Store changes task which loads data from Oracle to ADLS(parquet snappy format). But it is failing for one table during Full load with the error:
Hi everyone!
Currently we are migrating from Qlik on premise to SaaS. We have an app where we show a data dictionary describing the use of fields, master dimensions and master measures that we use in that app.
We extract that from executing a .exe inside server. I'm looking for any way to do extract same information. I only have found fields information from "App Analyzer". But for master items we haven't found a proper way to do this.
Is there a native way in this version of qlik cloud to do that? I attach examples of information that we show.
Thanks a lot for your help!
I have a set of Qliksense report where a user selects a period which then updates all results in charts with results up to this month, based on variables to drive set analysis for year to date, current period &c.
I have setup an Nprinting on demand report which generates the required tables into an excel based pdf format for distribution. The aim being that the user will choose a period, check results and then export multiple charts onto a PDF for distribution.
My issue is that when the user selects a period using a field filter (an island table to avoid affecting results directly) the on-demand report is not taking the selection into account. The report is returning for example the May results even if June is selected. I have also applied other filters which will affect the results directly (such as category) and this is also not passed to NPrinting.
I have set connections up with and without 'apply section access'. Report does not have any NPrinting filters applied.
NPrinting May 2022 v 22.15.2.0
Qliksense May 2022 patch 2
Following the documentation for editing users in the qlik-cli we are getting errors when attempting to edit a user
https://qlik.dev/toolkits/qlik-cli/user/user-edit/
We've tried a bunch of different variations for changing the user email address so we can migrate to a new identity provider.
//If we enter
qlik user edit <userid>
//then a notepad window pops up and with the user content
//which we can edit without issue but the help for the command
//shows how to use a --body flag but no matter how we code
//that one we get an error saying that the flag --body does
//not exist
//Here is the text from the command help
qlik user edit <userId> --body '[{"op":"replace","path":"/name","value":<value>}]'
Does anybody have any suggestion for this syntax
Bonjour,
J'ai débuté Qlik Sense il y a quelques jours, et après avoir cherché pas mal de temps, je n'ai pas trouvé la réponse à ma question :
J'ai une table qui contient des champs, et je voudrais que lorsque je clique sur un champ, toute la ligne devient sélectionnée. Sauf que, quand je clique sur cette ligne, il faut que la table reste inchangée, que ça n'affecte pas les autres lignes de celle-ci, mais il ne faut pas que ce soit en "Read-Only" car la ligne sélectionnée d'interagir avec une autre table.
Merci d'avance pour vos réponses, je reste disponible si vous avez des questions. 😄
Is there anything different in formatting numbers in Qliksense vs Qlikview when exporting data to Excel? We noticed that some numbers in Qliksense are not identified as numbers when doing a vlookup after exporting data. I have chart in QS where ItemID (number) is used as dimension. When exported to Excel and validating data against Qlikview, the vlookup returns #N/A, even though Excel does recognize the Qliksense exported data as numbers. Column explanation to chart :
Only if i used vLookup with numbervalue, i was able to match numbers properly. This is confusing why some numbers in Qliksense are recognized as numbers while some not.
I noticed that when i click 'enter' on the cells in col A that are not matched, the value is recognized by the vLookup as number and i get a match.
I am attaching the Excel file here. Anyone has experienced the similar issue?
I have a job designed to extracts values from XML file using tXMLMap. Pipeline fails when it tries to extract value from XML with no values in it.
I want the pipeline to continue processing other XML and skip empty XML files.
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.
Help us improve your Qlik experience by participating in our customer survey! The survey will be live from May 27 - June 14.
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 enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!