Hello Qlik Experts,

I m trying to combine multiple table while maintaining relationship between them. How should i achieve this? PFA data model for reference

Boa noite,

Meu objetivo é criar uma variável que receba valores diferentes a partir das escolhas no painel de filtro da figura abaixo. Essa variável assumiria por exemplo, os seguintes valores:

Se o usuário escolher Despesa de Pessoal e Despesa Discricionária, "PD";
Se o usuário escolher Despesa de Pessoal e Despesa Compromissada, "PC";
Se o usuário escolher Despesa de Discricionária e Despesa Compromissada, "DC, e assim sucessivamente.

Quero utilizar essa variável em uma expressão de cálculo em uma tabela dinâmica. Tentei utilizar a função "Set" para criar variáveis mas parece que só é disponível no script.

É possível fazer isso?

Obrigado,
Gustavo

Hello experts, I am new to qlik and I need to compare multiple columns from two unrelated tables to produce a column with dynamic outcomes. 

Both of my tables have millions of records, so I can't do a cartesian join. 

Table 1: travel_desitnation

Table 2: available_destinations

Input: user can select 1 or more destinations from table 1

Output: score each rows in table 2 to determine the proximity of its destination to the input destination(2) 

Please see example in attachment. Thank you in advance!  

Does anyone know of an extension or other option that makes the App Overview look more like a Power Point slide sorter.  I have an older user who is struggling using Qlik Sense and developing a story or message without resorting to printing all the sheets and rearranging them manually and then having someone else putting the sheets in the same order in the app as they are on paper.

We are using box plots to look at a small (700 value) dataset.  

We want to exclude values that are either null or zero.  

What is the best way to achieve this?  

Hi @Sue_Macaluso , @Melissa_Potvin 

Error from the screenshot drives me crazy. All content was written using controlls available in message editor. Then you when you want to publish message it screams: "correct the highlighted errors and try again", but there is no highlighter error... There is message at the bottom " Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied."

I am sattisified so When I click to post it again it shows the same error again... and again... and then since I tried couple of times it thinks I am posting the same message few times and blocks me from posting it at all

"Correct the highlighted errors and try again.Post flooding detected (user tried to post more than 2 messages within 5 seconds)"

It happens so often that it puts me off from community as I am spending time to write something, but then I am unable to post it...

I dont get why would I get the first error since I wrote everything without any copy/pase, I just logged on to new session on community etc...

Could you please comment on that?

Thanks Lech!

The nPrinting email drops off/sends blank KPI chart. This is not occurring regularly but this had happened once  in 2 different nprinting emails that pulls data from 2 different Qliksense apps. 

The task execution looks fine.  only thing that is common is that they both are KPI charts and doesn't have any filter applied on them.

does anyone had experienced this before? any recommendations to solve this issue? 

@Nicole-Smith

I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for the quarter data. So I need the columns 'Monthstart()' and 'Yearstart()' Please help!

Original formula for Quarter data column

=SUM(IF(QUARTERSTART(OT_Period)='10/01/2020',OT_Overtime_YTD))

The 'OT_Overtime_YTD' is the dollar amounts. Essentially the columns would be. 

Region/Location/Employee/Monthstart()/Yearstart()

We are trying to set up an action on sheet to 'select values in a field' - the action should be that when the sheet is opened the current 'Month-Year' is selected from the MonthYear field - but it does not currently work.

We are using the formula Date(Today(),'MMM-YYYY') to find today's Month-Year, this returns the value 'Mar-2021', and we can see that we have a value of 'Mar-2021' in our MonthYear field. When we close the app and reopen, or just navigate away from the sheet and then back to it, the selection is not applied.

We have tried replacing the formula with a hard-coded text string  of 'Mar-2021' and this also does not work.

Has anyone else experienced this issue in SaaS?