Hi All

I have Updated_Date column and I need to create Month column based on the date column.

Requirement like I need to create a "Month_A1" column with last date in the month which is available in Updated_date column for example "Month_A1"

Base on Updated_date column I need to create Month_A1

in Month_A1 fields like

Final results be like 

If I select May-2022 in Month_A1 column I need to see only "Completed" as 30

I need this month column created in Script and in front end filter as well.

Thanks in advance.

Hello everyone,

I have been working on this problem for a few days now with no luck and hence reaching out to you all here. I have a bar chart with the  bar measure as:

Count(distinct {<[ProductCode]-={'Finance Spread'},[leasetype]={'L'}>+<[ProductCode]={'Finance Spread'},[leasetype]={'P'}>+<[ProductCode]-={'Finance Spread'},[leasetype]={'P'}>}[dealno])

This results in the following chart

The issue is if I Select 'VSC' from the filter, 'Finance spread' Still stays in the selection. 

To solve this, I tried to change the measure to (Added the '$' sign): 

Count(distinct $ {<[ProductCode]-={'Finance Spread'},[leasetype]={'L'}>+<[ProductCode]={'Finance Spread'},[leasetype]={'P'}>+<[ProductCode]-={'Finance Spread'},[leasetype]={'P'}>}[dealno])

Now this shows the correct selection but gives me the wrong count. 

Is there any other way I could do this and get the correct count and selection?

Any help is highly appreciated. 

Thank you!

I am trying to replace an number within a data set but only when it meets a certain criteria. I am having to use 2 separate tables as the data is stored in independent areas.

My script example is as below:

Test:

 Load

JobNo

JobRef

JobStart

From 1st QVD

outer join

Load

JobNo

CompanyCode

From 2nd QVD

Jointable:
Load
If(WildMatch(JobRef,'*ABC*'),Replace(CompanyCode,'126','134'),
If(WildMatch(JobRef,'*XYZ*'),Replace(CompanyCode,'126','125'),CompanyCode)) as NewCode
Resident TEST

I am trying to replace the codes where the job ref meets criteria of containing a value as these have been miss assigned but with a consistency in the ref allowing me to identify which need to go where. 

When I run this and filter for job ref it returns every Code instead of just replacing the one one code. 

Hello Experts,

I have a calulated dimension as below which I wanted to sort in a particular sort order 

Expression :

=if( aggr(sum(Sales),Admin_ID)/1000000>=100 and aggr(sum(Sales),Admin_ID)/1000000<=500,'100M - 500M',

IF(aggr(sum(Sales),Admin_ID)/1000000>=50 and aggr(sum(Sales),Admin_ID)/1000000<100,'50M-99.9M',

IF(aggr(sum(Sales),Admin_ID)/1000000>=25 and aggr(sum(Sales),Admin_ID)/1000000<50,'25M-49.9M',

IF(aggr(sum(Sales),Admin_ID)/1000000>=10 and aggr(sum(Sales),Admin_ID)/1000000<25,'10M-24.9M')
)

)
)

Sort otder I want is same as in Expression, but not sure how to write an expression for sorting.

Thanks in advance.

Hi,

I have a problem with license monitor application.

When I reload it, I get this error:

ERROR: No license usage data found. Reload aborted. Please verify that the following data connections are correct: ArchivedLogsFolder, ServerLogFolder.

The connection string for ArchivedLogsFolder are:

 \\<FQDN>\<QlikShare>\ArchivedLogs

The connection string for ServerLogFolder are:

C:\ProgramData\Qlik\Sense\Log\

How can I fix it?

The version is Qlik Sense November 2020 Patch 6 - 13.102.13

We would like to automate the adding of endpoints to Qlik Replicate without having to use the GUI. The automation is required to be non-interactive since it will run from a batch scheduler. I am aware that tasks can be imported outside of the GUI (via the JSON files) but cannot see how to create endpoints via an import.

Is it possible to do this ?

Thanks

PC

Hi colleagues, 

Please help with Filter codes.
I need to do a filter pane check:
If Filter is not chosen, show sum on Key pane.
I mean, I have filter with dates (years and days). 

And I have a Key pane with Clients sum.
And i can't make that if filter is not chosen, Key pane must show “-” symbol, or something like “chose a period”. 

Please help to realize the code.
Thanks a lot 🙂

Hola,

Tengo un set de datos que se ve así:

Donde el date1 es el día en el que un cliente entra al negocio y el date2 es el día en el que sale.

Quiero obtener la entrada de clientes neta por día (clientes que entrar menos los que salen).

De momento tengo estos dos gráficos:

Dimension: Date 1

Medida: count(id)

Dimension: DATE 2

Medida: count(id)

Lo que quiero es obtener la resta de lo que se muestra en estos dos gráficos, pero no se como debería programar la medida o dimensión ya que ambos tienen la misma medida pero diferentes dimensiones.

Gracias de antemano!!!

Hello Qlik Geeks, 

I want to merge blank/empty values of a field RI to 'N' . I am using the below script to do that and it is not working. May I know what am i missing here ? Thank you in Advance

If(Isnull(RI), 'N', RI) as RI

Thank you,

CVR