Im trying to get a sum of sales for all account IDs that has mains for a prior year

Sum({<
Year={$(=(v.Date.Year.Max)-1)},
[AccountID] = P({<[Product Category]={[Mains]}>})
>}Sales)

If i exclude the Year section it gives me the values for this year however once i add the year -1 it throws me out Zeros. Any help will be greatly apprectiated

Hello ,

I have a problem with my connector of LDAP cannot retrieve users 

even if the sync work and the task is succesfull 

in the log I see :

Children not reachable  for ldap  and database done with 0 users and 0 groups even if with ldap admin when I write the same path I have my users 

my path is LDAP ://myIP/dc=X,dc,Z,dc,Y

I tried also with 

LDAP ://myIP/ou=users,dc=X,dc,Z,dc,Y

and with additionnal filters like 

(&(objectCategory=person)(objectClass=user)
(cn=*)) 

but it doesn't work  my version of qlik sense is june 2019 sr3 and my OS is windows server 2012 

thank you for your help 

I have my sample data which is this: 

What I want to get is the most sold product for each week.

What I did on Qlik was to add week, category and this formula -> 'max(aggr(sum(num_orders), week, category))'

To get the most sold product, but the category dimension makes all the categories appear.

What should I do to filter it and make it so only the most sold category appears?

Hi everyone,

I have created a bookmark in my app and set this  as the app default, so that it is applied when opening the app.  This works fine on the Qlik Sense server, but it is not applied when migrating the app to my QAP server and using it in a mashup, even though I can see that the bookmark has been migrated (by looking in the single configurator in the dev hub).  Could someone from Qlik please confirm this?

In the meantime, I have used the applyBookmark method.

Thanks in advance.

Richard

Hello

I have to calculate avg sales per client in every town, in every month.  Then for every town mark clients with higher sales than average. I have little experience with "IF" and  I don't now how to make link client sales with town average.
I tried this:
IF((sum(Sales))>(Aggr((Sum([Sales])),[Town],[date.autoCalendar.YearMonth])/Count ( distinct [Client])),1,0)

Hi All

I am currently evaluating Qliksense, and like the clean appearance.

I have a map which shows my distribution centers to customers, and set the color by expression so it highlights customers who have not orders, in the same map I also have set the color by Dimension so each center is a different color. What I would like to do is give the user the ability to switch between color by expression to color by Dimension and back again as required. Is this possible?

Thanks for your help

Chris

Hello everyone,

I have just installed a fresh copy of September 2019 Qlik Sense on a brand new dev server and noticed that both License Monitor and Operations Monitor apps are failing to reload at the same place. Here's a snippet of the script from log files where tasks fail:

License Monitor

CALL QRS // Call QRS data AFTER LogContent table is stored
LET NumRowsQRS = 0
SET QRS_RowCounts = 'QRS Row Counts: '
For each endpoint in 'monitor_apps_REST_license_user','monitor_apps_REST_license_login','monitor_apps_REST_user','monitor_apps_REST_license_access','monitor_apps_REST_app','monitor_apps_REST_license'
CALL monitor_apps_REST_license_user
Set NumRows_monitor_apps_REST_license_user = 0
License_User_Access_Types:
NoConcatenate Load * Inline [UserId]
1 fields found: UserId,
0 lines fetched
For Each tipo in 'User','Professional','Analyzer'
LET f_unused = '[Unused UserId' & if(tipo='user',']',' User]')
LET f_quarantine = '[Quarantined UserId' & if(tipo='user',']',' User]')
LET tipo_lower = lower(tipo)
LIB CONNECT TO 'monitor_apps_REST_license_user'
Error: Connection aborted (System error: The handle is invalid.)
Execution Failed
Execution finished.

Operations Monitor

CALL QRS // Call QRS data AFTER LogContent table is stored
TRACE Fetching data from Qlik Sense Repository (QRS) database
Fetching data from Qlik Sense Repository (QRS) database

LET NumRowsQRS = 0
SET QRS_RowCounts = 'QRS Row Counts: '
For each endpoint in 'monitor_apps_REST_user','monitor_apps_REST_app','monitor_apps_REST_appobject','monitor_apps_REST_task'
CALL monitor_apps_REST_user
LIB CONNECT TO 'monitor_apps_REST_user_condensed'
Error: Connection aborted (System error: The handle is invalid.)
Execution Failed
Execution finished.

It seems like the there's something wrong with whatever QRS is. Some additional information about environment that I'm running Qlik Sense in:

• Single node environment
• Server is offline
  • As in, not allowed to be connected to internet

Has anyone faced this and found a solution? Any idea what I can try to get these apps up and running?

Mikhail B.

Hi to all.

I'm new of this forum and I have a question for you.

I have three qvd: one for the Contracts (with inside fields like "Business", "ContractCode", "Name", "Address", "Value", "ProductCode", etc), one for the Product (with inside fields like "Business", "ProductCode" and "ProductSales") and at the end one for Cover (with inside fields like "Business", "ContractCode" and "ProductCode").

I done this associations: Contracts with Cover throught "Business" and "ContractCode" and then the association betwenne Cover with Product throught "Business" and "ProductCode" to take "ProductSales").

I built some reports and is all right. But if I want  to know the value for ProductSales I have all ProductSales with the same value. I think that I wrong the associations.

Is there someone that give me a advise?

Thanks for all.

ciao

ale