Date             Time Spent

3/5/2024            5

3/15/2024          8

4/17/2024          7

4/24/2024          5

I have one table with above information.  I need to make a KPI where it only need show month of March's Sum.  Anyone can tell me what formula I need?  Thanks in advance.     

Hi,

I'm trying to calculate the contribution sales per store for each salesman.
I created   bar chart with this dimensions:

StoreID as group

and full name as bars.

my measure is:
aggr(sum(TotalPriceBeforVat),StoreHanut,SalesmanID)/sum( TOTAL <StoreHanut> TotalPriceBeforVat)

the issue is when I'm filtered on salesman -

I get this graph:

how can I divide by the store total sales that my salesman is part it's sales regardless my salesman selection?
I want to get the right percentage on the bar chart.

thanks!
 

Hello Community,

I am attempting to configure an on-premise TAC 8.0 using a GitHub account that has two-factor authentication enabled.

I've looked at another post here on this topic, but it didn’t resolve my issue. Is this configuration possible?

I've tried connecting to the GIT server on my Linux Ubuntu installation but haven't had any success.

Thanks in advance

Claudinei

Hi,


I'm struggeling to find the correct method to get the list of variable, measure and dimension of a specific app though the Dev API. Regarding the fact these are available throught the Qlik Cloud Services in automation, i'm a bit not to find this method in the API dev kit.

Any clud ?

Hello, 

I am panicking.

Changed data model and impacting my tables now. Now I have multiple rows of data with the same ProgramName with multiple Events and QlikSense is hiding data in the table. Just Added RecordID

I want to see NA and ProgramName A, Events 1 and 2.
Qliksense is Program A, but the Event Field is blank, but there is data there. 
Assume somehow I have to include Distinct events. Any recommendations?

Currently using:
IF(Region = 'NA' and ProgramName = 'A', [ProgramName],Null())

We had Qlik alerting feb 2021. I have upgraded nodeJS  to supported version V20.9.0 and restarted the server then installed Qlik alerting to July 2023 SR1 then restarted the VM.

but qlik alerting services are not visible or available in services.msc

also Qlik alerting not working 

how to resolve this issue

Hi everyone,

I have a table with a column called RelativeMonth and it has two types of values, one is the normal month and one is the MAT. For the normal month the format is 'YYY  MMM' (e.g. 2023 Apr). For the Mat it is 'Mat MMM YYY' (e.g. Mat Apr 2023).

In my script I am creating a new column called Period_Type that specifies whether the date is MAT or Month. So I want to have the values in the RelativeMonth column in the same format. That is why I am trying to transform the Mat values such as Mat Apr 2023 into the same format as the Month values (so 2023 Apr). The script I have come up with is this one:

tt:

LOAD
if(wildmatch(RelativeMonth, '*Mat*'), 'MAT', 'MONTH') as "PERIOD_TYPE",
If(wildmatch(RelativeMonth, '*Mat*'), date#(right(trim(RelativeMonth), 8)), RelativeMonth) as RelativeMonth,

from [lib://Monthly/monthly_new.qvd] (qvd);

Tp:
NoConcatenate load PERIOD_TYPE,
date(alt(num(date#(RelativeMonth, 'MMM YYYY')), num(date#(RelativeMonth, 'YYYY MMM'))), 'YYYY MMM') as RelativeMonth
resident tt;
drop table tt;

As you can see I had to create two separate tables so I can first get rid of the Mat part in front of the real date, and then in the second table I am trying to transform it into the same format as the monthly values. However, the date format I get is the following: 2022 abr. 

So the first letter is not capitalized, they use the Spanish writing (abr instead of apr) and a dot is added at the end. 

Does anyone know how to solve this? Also, do you think it is possible to put the transformation into just one single load statement, instead of having to cut out Mat in one load script and then do the reformatting in another?

Thank you so much!