Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am working on Qlik Sense Desktop and currently developing a Ad-Hoc combo chart with VizLib combo chart extension and users can select the dimension(s) and measure(s) to be displayed on the combo chart. I have 2 filter panes, one is for dimension and one is for measure. In order to filter out unselected dimension(s) or measure(s), I used calculated conditions in the data section. I have both integer values (in millions) and percentage values for the measures, thus, I used the primary y-axis for the integer values and secondary y-axis for the percentage values. The combo chart displays the bars and lines correctly when I have both measures from primary and secondary axis selected or just measures from the secondary axis (which are the percentage values). When I only have measures from the primary axis selected, weirdly, the values in the primary axis alongside the lines or bars will be displayed too high and are not visible within the chart. The range of the values on the primary axis are all off, it will only work if I set the Min/Max values manually but its not practical. I set all the formatting to auto for all the measures and the problem still persist. Is there a way to make the chart's axis display the values range dynamically or is there some settings that I missed from VizLib combo chart? Any help would be greatly appreciated.
Hi,
I have a situation where null values are created by another dimension, not true null. I can give these a value by using a count, the return will be 0, then i use if the count = 0 give a value. This is now selectable in the table. Great!
if(aggr(count([Standard Name]),[Production Facility])=0,'No Standards')
However, i now need a button to filter these values and i am struggling to get this. I have tried a few thing with non working. Like using Select values matching search criteria and the value 'No Standards' But i guess this is not a real value!
Does anyone know how i can use a button to filter the created 'No Standards' in the field Standard Name?
Thank you in advance.
Daniel
Hi ,
Can you give some example how to gives access group level qlik sense section access.
I have some requirement like below:
let's we have Total 6 user: They are divided into 2 Group.
How to Give access 2 group different level country access.
ex: 1st group need IND,USA access
2nd group need UK,AUS access
I have provided the Data below
Sales:
Load * inline
[
Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300
2019, USA, 120
2020, USA, 220
2021, USA, 500
2019, UK, 350
2020, UK, 650
2021, UK, 150
2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];
Hi,
I have a fact table (f_table) and dimension table (d_table) with below fields.
f_table: country_cd, measure_1
d_table: country_cd, country_desc
In Qlik Sense data manager, I associate both the tables on country_cd field.
Now I add a bar chart to display measure_1 against country_desc. There are many country codes in my fact table which are not in dimension table. All these are displayed against '-' in my bar chart. But I want to display it as 'Unknown'.
I tried changing the dimension (in bar chart) from just "country_desc" to "if(isnull(country_desc), 'Unknown',country_desc)" but it does not help.
Appreciate any suggestions. Thanks!
Hello
I have problem with synth keys. Im trying to solve it by preparing key but it won't work.
Here's my data:
LOAD
ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
RESULTS1
RESULTS2
RESULTS3 ...
2nd table
ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
DIF_RESULTS1
DIF_RESULTS2
DIF_RESULTS3 ...
How to prepare a key which will connect PTT and PROD_ORDER_NO without syth key, so that i will still be able to use PTT or PROD_ORDER_NO filter?
How to implement custom properties in a load balancing rule for a Scheduler, where any tasks that applications have these custom properties run only on the designated node.
Ex.:
I have this scenario, Node Central and RIM. Some applications need execute task (schedule resource) in a RIM node e others in Central Node.
App A > Consuming resource for this node Central.
App B > Consuming rosource for this RIM.
Doing custom properties for a separete an level the app, only resource engine forwad for RIM, anyway task in QMC have a priority execute in Central node first.
This is possible? Managed where this task is executed and consumition resource for node RIM?
Hi all,
Please, can anyone explain or send me a link that explain step by step on how to us VB Script Macros to Send email through Outlook In QlikView?
Thanks
Hi all,
I need to fetch the image from the excel source. and I need to display the image in front-end table respective to ID field.
Its an high priority task, Assist me as soon as possible.
Thanks in advance!
#
I need to multiply the value 300,000 in column 2 * the Rank(Relative). But I can't get the correct value.
What would the set analysis look like between column 2 * column 3?
Cod | Descrição do Produto | =300000.00 | Rank | Column(2) * Column(3) |
Curret |
10757 | Papel Hig Rolao 8x300 Lirios Branco | 300000 | 7,27% | 15025827000,00 | 9020,773 |
12305 | Fita Ades. Plast. 48x50 Ref.300 TRA Transp. | 300000 | 4,10% | 8461812000,00 | 63619,31 |
13248 | Arquivo Morto Pap. Ond. Compacto Ref.1170 Marrom | 300000 | 3,01% | 6213060000,00 | 12285,75 |
13697 | Papel Hig Rolao 8x300 Lirios 100%Cel | 300000 | 11,97% | 24739770000,00 | 14068,45 |
16923 | Seven Denso Desengraxante Plus 1:100 5Lt Ref.5260 | 300000 | 6,23% | 12882420000,00 | 4802,176 |
17459 | Papel Sulf. A4 75g/m² 500Fls Branco Chamex | 300000 | 24,93% | 51509256000,00 | 35919,8 |
19201 | Papel Toalha Bob 8x100m Bromelia 100%Cel | 300000 | 5,18% | 10710954000,00 | 21816,07 |
19303 | Papel Hig Rolao 8x500 Lirios 100%Cel | 300000 | 6,45% | 13334085000,00 | 19359,82 |
2061 | Lápis Dermatográfico Ref.7600 Branco Mitsubishi | 300000 | 4,69% | 9689652000,00 | 74786,54 |
29976 | Luva Nitríl. s/Pó c/100Un PQ Talge Ref.7240 Azul | 300000 | 1,60% | 3307500000,00 | 15551,29 |
5277 | Copo Desc. 180ml c/100Un Branco Copobras | 300000 | 21,21% | 43817820000,00 | 10065,97 |
5543 | Pincel Marc. p/Retrop. 2.0 Azul Pilot | 300000 | 3,36% | 6932937000,00 | 18704,05 |
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.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
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!