So I have a table in my sheet in which I have amount, description and year so I want to have a column for the amount of the previous year for all the materials so that when we select any particular year the amount of the year selected and the amount of the previous year should come, how can it be done, I have tried set expressions but the desired output is not coming.

Hello

We have a Qlik CDC only task and we performed a modification on a filer transformation on a table.

We stopped that task , perform Import task with the desired modifications and perform (for mistake) resume processing of the same task.

The filer was loaded correctly (and unexpectedly !)

We remember in the past documentation that , if we have to perform a filter modification, we are aware that we will perform stop+import of the task (or perform modification by Qlik Enterprise Manager GUI and save the currently running task) and perform reload target

Can you explain us what happened ? in what case resume processing is acceptable for filter modifications scanarios ?

Lt us know

Regards

Alessandro Ferrario

Preciso achar o Valor da Coluna 1 * Coluna 2(Relativo). Mas não estou conseguido.

Preciso criar um set analysis que trate (Pois o valor correto é diferente). 

Preciso de ajuda. 

I have an Application, In that a button is given to reload the data from the Sheet. Is there any possibility that the reload can be the done from the user end after publishing and giving access to the users to that dashboard.

Thanks in Advance.

Hi Community,

In which table in postgres can I find information regarding the visualization used in my app. From the table AppObjects I did get the sheet Id, but where can I find the information regrading the visualizations in the sheets.

Any help would be appreciated.

Hello,

I noticed a strange behavior according to I use a dimension or a level.

In my table, I use 2 levels and a dimension + several measures contained in a Qlik table. When I want to replace the dimension by a level, all records with 0 for current year are removed, whereas they have amounts for previous year. This is not happened when I use the dimension from the Qlik table.

3 levels:

2 levels + 1 dimension:

Do you have an idea? Is it a bug?

It is really annoying because in another column I need to calculate the difference between two measures. The loop doesn't work if I use 2 levels + 1 dimension.

Thanks for your help.

Regards,

Pauline

Hello

I need some help 😉

I have dimension AA with values 'one' and 'two'

I have another dimension BB with values 'red' and 'green'

I have several  variables:

one_red = 1,  one_green=2, two_red=3, two_green=4

how can I build my formula so that when looping through the table, each cell in the table is the right combination?

Pivot table: 

               red  |  green

one          1          2

two           3         4

I tried : $(=Only(AA)) & '_' & $(=Only(BB))   right but not evaluated as a varible 😞

Any help will be welcome... Thank's 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?