Hi.
I use GetCurrentSelecton to get dynamically rolling months backwards according to the following code:
If (
[Period] <= GetFieldSelections (Period)
and
[Period]> GetFieldSelections (Period) -100
,Period
)

It works great as long as you only choose one period in the filter.

Is it possible to make it so that if the user selects 202010, 202011 and 202012 in the filter, the function only returns the highest value (use 202012 as Period) or the lowest(use 202010 as Period)?
I have tried to use Min(Period) and Max(Period) in the function but only gets errors.

Boa noite!

Sou um mero usuário desta ferramenta e estou com uma demanda. A empresa onde trabalho utiliza um Painel desenvolvido em QV, neste painel ela disponibiliza dados de produtividade de toda a empresa, eu preciso fazer a extração da produtividade de uma equipe especifica, porém atualmente eu teria de fazer várias consultas para gerar uma planilha. Eu gostaria de saber se há uma possibilidade de alterar os filtros e escolher apenas os integrantes de uma determinada equipe?

Peço desculpas pela pergunta confusa.

I recently upgraded from Qlik Sense 3.2 to the June 2017 version following the instructions here. 

The upgrade said it was successful but the QMC or Hub will not open using the shortcuts. 

The services are all running and I've tried from localhost and using the domain name but no luck.

Am I missing something here?

I have a dataset that I need to use to derive a calendar or expanded table for every day of the year for multiple calendar years.

An example data table is shown below.

For ID = 1, I need the 'Value' field to be 4 for everyday before 1/1/2020 until the 'Modified Date' of 5/27/2020, when the Value changes to 6.  Then, I need the Value to be 6 starting on 5/27/2020 and every day after that.  How would I create a calendar or new table for multiple different IDs with different Values and different Modified Dates?

Hi there

Please find attached.

The model is self explanatory. I'm trying to do a Set Analysis in the Blue Text box for the Current Fin Year (20/21) and it should return 5.17, but it doesnt. I'm almost sure it is the syntax, because FY is Dual.

1. From research I have done I got - the set comparison always compares against the text value of a dual. So I created a variable called vFY.

2. The result that I am getting is not correct.  what is wrong with my Set Analysis?

Much appreciated.

Thank you.

Hi Team,

I have this Graph, Where I am representing month wise Salary. I want only month from April to March. But I have the data till September.

I have used this dimension - =If([Recruitment Year Month]<>'Jan 2021' and [Recruitment Year Month]<>'Feb 2021' and [Recruitment Year Month]<>'Mar 2021',[Recruitment Year Month]).

How I can increase till March 2022. If I do not have data for after Sep 2021.

Thanks.

Hi All,

Below is my expression :  I want to restrict this value on month field selections but should work on YEAR selection. I tried restricting using MONTH= but it is not working

(((sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])//,month([EXPENDITURE DATE]))
/
sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},baseline_flag={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[BUDGETED AMOUNT]))
*
sum({< ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[CONTRACTUAL AMOUNT]))
-
(sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])))
/
((sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[ACTUAL COST])//,month([EXPENDITURE DATE]))
/
sum({<ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},baseline_flag={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[BUDGETED AMOUNT]))
*
sum({< ProjectFlag={'Y'},EXPENDITURE_FLAG={'Y'},PROJECT_START_MONTH={"<=$(=addmonths(monthend(max(CALDATE)),1))>=$(=yearstart(monthstart(max(CALDATE))))"},MONTH=>}[CONTRACTUAL AMOUNT]))

Please help.

Thank you.

Hello all,

I am facing problem in deriving the solution for below problem

Load 

dt_diff, sequence

5  , 1

45, 2

90, 3

180, 4

270, 5

I wanted a solution like this  below

dt_diff, sequence

5  , 0

45, 1

90, 2

180, 3

270, 4

Anything  less than dt_diff  45 should come under the sequence 0, then it should populate sequentially

hope my question is clear

any inputs appreciated

Hello all,

I have already imported those fields as an example:

My ouput should look like:

Operation: If value (Field_a) >5 then value(Field_b)=value(Field_a)*2*Year else value(Field_b)=value(Field_a)*Year/2 

NB: These operations should be performed in the script and not as a chart expression.

Any help please?

Thanks in advance

Hi,

When trying to create the WH. COmpose is throwing the following error.

However, validate of the model does not show anything.

Any, suggestions where I should be looking at to debug this error message?

Thanks,