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. 

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 –

I have tried to use the format column and &nbsp 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?