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

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

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

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?

Good day

Live story slides are really useless to us without being able to filter on the underlying sheets. 

Qlik seems to ignores the current selections made in the dashboard.  

Is there a way to export the data to PDF/PPT per current selections? (embedding a live sheet in the story and capture the latest filters). 
Please help. The entire project is hinged on this! 

Qlik Cloud 

Hi everyone,

we are facing issue with custom filter (inline load filter) , selections are are not working with respect to that selection- how  that filter will work

we have multiple filters but 3 are important year and month and filter

1)user will select year and month and Filter(Custom Field) then chart respond based on selection only and legends as well

2)user will select multiple year and multiple months and multiple filter fields based on that selections
data has to show selected one only- Legends as well

3) user will select only filter then selected data has to respond - Legends as well

need your help on this issue.

Hi, Below is the master calander we are using and the fiscal start month is = 7.

Here I want o calculate the daynumber starting month July every year.

Datefield:
LOAD date($(varMinDate)+IterNo()-1) AS DateNum_Fisacal
AUTOGENERATE (1)
WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);
Set vFM = 7 ; // First month of fiscal year

Calendar:

Load * ,Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year
Dual(Month_F2, fMonth) as FMonth; // Dual fiscal month

Load *,Year_F2 + If(Month_F2>=$(vFM), 1, 0) as fYear, // Numeric fiscal year

Mod(Month_F2-$(vFM), 12)+1 as fMonth; // Numeric fiscal month

Load Year(DateNum_Fisacal) as Year_F2, // Your standard master calendar

Month(DateNum_Fisacal) as Month_F2,

DateNum_Fisacal

Resident Datefield;