Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter
if(Gender='F','Female',if(Gender='M','Male')). it works fine.
Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.
I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')
the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.
could someone help please?
Thank you!
Hello:
We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as it is being replicated?
Thanks,
Manas.
Tenho a seguinte situação:
Para cada registro tenho um COD, e um ano_inicio e ano Fim, preciso que crie pra cada COD, as linhas informando que ele permaneceu de ano_inicio até ano_fim.
Exemplo:
COD | ANO_INICIO | ANO_FIM
1 | 2002 | 2005
2 | 2006 | 2008
Resultado esperado:
COD | ANO_PERMANC
1 | 2002
1 | 2003
1 | 2004
1 | 2005
2 | 2006
2 | 2007
2 | 2008
Consegui fazer quando no LOAD filtro apenas um COD, segue QVW.
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.
What API should I use if I want to obtain a list of all my datasources in Qlik? For example, I configured a Postgres connection and extracted 2 tables. Now I would like to get this info from the API - table names, table columns.
I have a map below, which related food to fcode. fcode is the key that links multiple tables together.
map1:
[food,fcode
apple,a
apple-pie,a
banana,b
banana-float,b
cherry,c
cherry-coke,c];
Let's say
Table 1 -uses fruits (applymap() can be used to turn food into fcode)
Table 2 -uses fcode (can not reverse into food)
Table 3 -uses fcode (can not reverse into food)
How can i create a filter, such that:
1. the filter display the food values. (i.e apple-pie and not 'a')
2. When selecting food values, the filter is applied to all tables (1,2,3). I.e if I select apple-pie (or apple), the filter also set fcode to 'a' and table 2,3 will display only information relating to 'a'. Note that it is accepted for either apple-pie or apple to be selected to filter for fcode 'a'
If I use applymap() on table 1, and filter by fcode, i lose context for my users who only understands food.
I've got an automation that uses the GitHub connection. It works fine and then all of a sudden stops working. It seems to be a permissions/token thing from Github, but I cannot find a simple way to fix it. I cannot refresh the connection, I cannot delete the connection and re-connect without first deleting the automations that uses the connection. So, the only way I have currently to fix this issue is to: 1. delete all automations that uses the connection, 2. delete the connection, 3. re-import the automation, 4. re-establish the github connection (and 5. since we trigger the automations from github, reset the variables and settings to match the new instance of the automation). This is an extremely time consuming process to have to do every couple of weeks or so (yes, the connection seems to be failing within a month). Is there anyway to refresh/update the permissions for the github connection without having to just nuke everything and re-build it?
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.
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!