I am currently on Qlikview version 11.20.13206.0 SR13 as this is what our ERP is contracted with and makes available.  It is fine for our data table and graph uses, but I am looking to add some visualizations and map (heat map/location mapping) to help our logistics and operations departments.  I know there are some archived posts that I can't seem to reach that detailed how to utilize add-ins to accomplish this, just wanted to know if anyone has integrated any maps recently and what the best way to go about this is, or has any help or guidance to provide.

Thanks in advance.

Hi,

We have one Enterprise Manager server for our lower environments replication monitoring.

Problem, even though I put tags on tasks, people still make mistakes and change the wrong task on the wrong environment.

I would like to change the lines colors in a way that leave little room for mistakes.

How can I do that? 

Dear ALL

We are not getting below error while writing below css code in custom css window of "Advanced KPI" object 

Also we tried below code 

& .qv-inner-object {
  border: 3px solid #fff;
  border-radius: 20px;
} 

& .qv-object-advanced-kpi {
  border-radius: 25px !important;
}

& article {
  border: 0px !important;
}

I have a script that loops through a network folder and all subfolders. if the target is an xlsm file, it should open, grab data, append it to the existing dataset, and continue on to the next file. this is mostly working.

I've turned off the error mode so if there is an error loading data from a file due to someone having the file open already (error "... it is being used by another process. (DirectAccess-5016))"), it continues to the next.

My issue is the load statements that are executed after this error no longer load data into the dataset. no additional error is thrown for these future load statements, but the script is functioning as if they had an error even though they wouldnt if the first error did not occur. I've added a check just after the load to check the scripterror variable by saving it to a variable and checking if it = 0 or not but the value never changes from <NULL> in the debug or if i trace the value it just prints the time. so I can't see what the script error value is even though my check of "If scripterror = 0" always results in false.

Anyone ever run into an issue like this?

hi all,

i want to create a self service pivot in qlik cloud. i want a drop down listbox with multiple dimensions that users can select, and that the dimension will be added to the pivot (can be multiple). and same for measures. anyone any idea how to this or has an example?

thanks in advance!

Hello
I have a pivot table with several expressions
I will show you 2 expressions 1 and 2 written in two different ways but they return the same correct result

expression 1 is not distributed on any dimension
while expression 2 is distributed on any dimension

but expression 2 is very slow when used with the remaining expressions in the pivot table
while expression 1 is much faster

Expression1:
{
$
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>
}
sum(SPENT_MANDAYS)

Expression 2:

(
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>}
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>}
sum(SPENT_MANDAYS)
)

kindly advise on why expression 1 is alwys under null scenario type

Hi, I need implement the logic if one gcin have 1 limit id then show min of seller limit , but if 1 gcin have move than one limit id then it show  some of distinct  Seller limit  and in total it show 89,420,000. I am using this formula to display seller limit =if(Aggr(Count(DISTINCT[Seller Limit ID]),[Seller GCIN])=1,
num( ( min({<Month,Year,YearMonth,MonthNum,DateNum ={"$(vMaxDateNum)"},Flag_Lopt={1},Flag_Capt={1}>}[Seller Limit])),'#,##0'),
num( ( sum(DISTINCT{<Month,Year,YearMonth,MonthNum,DateNum ={"$(vMaxDateNum)"},Flag_Lopt={1},Flag_Capt={1}>}[Seller Limit])),'#,##0'))

But  formula show 44,710,000 in total because of different Seller code