Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have sections in my data load script.
Currently, I have two sections, and they are pulling data from entirely different tables. However, they appeared to be linked. When I go to the pivot, it pulls data based on a selection of the other sections.
How can I have each data pulled from their respective sections?
Also, it is slowing the application.
I'm facing a problem with a combo chart.
I want to show the maximum and the minimum value of a measure (only two highlighters), but minimum highlighter appears repeatedly in every month and far from the line.
Can someone help me, please?
MEASURE (line): count(distinct Chave_Contrato)
HIGHLIGHTERS
Max: =if(count(distinct Chave_Contrato)=max(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)
Min: =if(count(distinct Chave_Contrato)=min(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)
Thanks!
I've simplified my data model in the follow table with some sample data.
To give some context, the data exists out of 3 concatenated data sets:
1. Email
2. Email + Email Content Block
3. Email + Email Content Block + Product
An email can have multiple content blocks
Content blocks can contain multiple products
When i select email 1, i get a nice overview with the included content blocks and Products.
However, i also want to do this vice versa. Hence, when i select CTN i want to see the linked content blocks and emails and the respective #Send value.
See below for the desired output:
Select Brush, i want to see the sends from row 4, because this email (1) does include this product.
I also want to see the sends from row 3, because this content block (A) also included this product.
And i also want to see, but that will anyway work, the sends from row 1, because those are the sends for this product.
Same method when i filter in the Cluster.
And same when is filtered on the Email Content Block.
hi,
i need help. we want to put a qlik app on tv screen with a Optisings solution. we have every time a mistake like this. what we can do that we don t have this? mistake 500. what is it?
I have a QV report that I inherited. It uses an Excel template to read in the left side row labels and the expressions for each cell. Then there is an inline table
This is the excel template-
Then the inline table -
Then the table uses _metric as a dimension. Here is the QV report
I am trying to format the row labels with indentation. I can make them bold by including
<b> in the _Format column.
I want to indent particular rows like such –
CHANGES IN THE STATEMENT OF PROFIT OR LOSS & OCI |
Modified Retrospective |
Fair Value |
Other |
Insurance Revenue |
Incurred claims and other insurance service expenses |
Amortization of insurance acquisition cash flows |
Losses and reversal of losses on onerous contracts |
Adjustments to liabilities for incurred claims |
Insurance Service Expense |
Investment components |
Insurance Service Result |
I have tried to use the format column and   to insert spaces, but that did not work
Is this possible to do ?
Any thoughts on this would be greatly appreciated.
Thanks,
Brian
I have two Q VD files (table1, table2) with the same column names, and I would like to append them into a single table called "final_table". The append operation should only occur when the primary keys do not match from both tables. However, with the current code, I am only seeing IDs from table1 appear, and IDs from table2 are not being included.
I would appreciate your guidance in resolving this issue.
LOAD *
From table1;
Concatenate LOAD * FROM table2
WHERE NOT Exists(id);
Hello
I'm reading a qvd file which contains data for a table that has a column whose data is in xml format
I'm reading the xml field and then parse it to get the fields in the xml tags along with their values
during reload I get an error saying
An invalid character was found in text content.
On line number: 1. On column number: 659.
but I don't have that number of columns?
Check attached QVW and QVD file
the script works fine if I put the condition where RecNo < 367
but if I remove this condition the script works fine - and I have to in order to read all data
can someone help me identify what might be wrong?
Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size&shape properties, there are two layers point layers and area layers, except size&shape all the properties are dimension, so How should I stop the dimension from reflecting from year-month?
right now after selecting it is removing countrys(area layer) and some station(point layer) when I select year-month.
Used expression: SUM({<[YEAR_MONTH]=>}[GEO_AVG_PRICE] * [GEO_QTY])
Before selecting year month filter:
after selecting (it shouldn't change anything, It should show the map as it was before as in above image):
Hello everyone,
please refer to snapshot , the input table has dates and classification column along with other columns. I want to create this shown output where latest classification is selected for each key as per week
note: week starts on Mon and ends on Sun. And I have highlighted dates falling in same week.
I want to do it at script level only.
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!