Hello:

I would like to calculate median, the IQR (25%, 75%), and min and max  of a count of values, by group. See example table below:

The desired output will be in pivot table, structure as follows:

I have spent a lot of time trying to figure how to calculate median/fractile (IQR) values from a count - I can't seem to figure this out.

Any help would be greatly appreciated.

Thank you,

Sin

I am wondering which scenario has the better performance in each of the pairs below.  The metric I am most interested in is visualization rendering time, both initially and in response to user selections.  I'm less concerned with memory consumption or load-script duration.

Measure = Sum(FieldA) * 1000  // 1. Aggregate first
Measure = Sum(FieldA * 1000)  // 2. Aggregate last

Measure = Sum(FieldA + FieldB)       // 1. Aggregate last
Measure = Sum(FieldA) + Sum(FieldB)  // 2. Aggregate first

NewField = FieldA * 1000  // 1. Make another field while loading data
Variable = FieldA * 1000  // 2. Make a variable instead using "Set var = ...;"

NewField = FieldA + FieldB  // 1. Make another field while loading data
Variable = FieldA + FieldB  // 2. Make a variable instead using "Set var = ...;"

In each case, I put the option that I think should result in more responsive visualizations first, but I don't have the empirical data or knowledge of what's under the hood to back it up.  I don't know 1) how the data is physically arranged in memory, 2) whether Qlik executes formulas as is or rearranges them for efficiency like SQL query optimizers, or 3) whether things like caching or preloading come into play.

Hi all,

I need some help with background layer TMS maps in Qlik Sense.

A colleage has created an awesome floorplan of our company, and has collected sensor data related to meeting room activity.

I am now trying to figure out why the background layer TMS map is super inconstant, sometimes the background layer appears and it looks fantastic, and other times the tiles just are blank surrounded by red lines, seems like the map does not render (see attachment).

I have checked that the files are located on the Qlik Sense server correctly and that the TMS URL String is correctly formated with the ${z}_${y}_${x}.png. It all looks fine.

Where am I going wrong? I have been looking through Qlik Support and googled like a crazy person, however no luck so far. All help is appreciated 🙂

Hi,

I'm a new user of Qlik and it seems that it suits perfectly my needs !

But I experience a bug really anoying that prevents me from using Qlik desktop : I loaded a big fact table (7 millions rows) with 3 small dimensions and 2 quite big (time and geography), from postgresql.

When I tested with a filtered database (loaded it with filter to have only few rows, like 20k or so), it worked nice and I created the app i wanted.

When I tried to do the same with the complete database (new app created), it loads, but quickly after that, when I edit sheets or else in app, Qlik starts using 100 % of my CPU and RAM and freezes PC so much I can't even move my mouse and kill the software : I have to reboot my PC.

It seems that it happens to some other users (see that post), but it's an old post. Is there any solution now about this ? Frankly, with that bug, Qlik is useless for me, as I plan to work on several databases of that type…

Thanks in advance !

Good morning,

I have a problem with a conditional format applied to the function network days.

The formula is :

Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])>7"}>}[SUBJECT])
//=NetWorkDays(YearStart(Today()), yearEnd(Today()))

The expectation of this formula is to count:

the times in which the number of days between these two fields is major of seven (without considering saturdays and sundays)

The problem I have occurs when I want to apply to this formula =0 or <0, instead of >7

For example:

Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])<0"}>}[SUBJECT])
//=NetWorkDays(YearStart(Today()), yearEnd(Today()))

For =0 i have a result but not sure is correct

for <0 the result is zero.

Is anyone can help me with this formula?

Thanks a lot for your support.

Hi! I have a task where the end goal is to get a table where i see, for each sale order;  either if it is an online order or who is the salesperson. The store sells online and directly (salesperson). I want the final table to look like this:

(example)
OrderID ---ResponsibleForSale

41424        John Johnson

12443        Online sales

I have one document, salesorders, where I have the Order IDs. In this document I also have a flag which is 1 if it is a online sale. This document is connected to territoryhistory-document through territoryID. The territory-document is then connected to the employee-doc through employeeID. In this doc we have the Salespersons name. If the employee is a salesperson the employee allways have employee ID above 273.

I tried with this script below, but it doesn´t work yet. (So the goal is; if onlineflag=1 - then write "online  sales" on that order-number row. If onlineflag=0 and employee ID > 273 (so it is a salesperson). Then write the sale persons name. Think about that they are not directly connected but connected through 1 doc in between. 

RepresentationList:

LOAD
SalesOrderID,
OrderDate,
OnlineOrderFlag,
TerritoryID,
IF(OnlineOrderFlag=1,'Online Sales', 0) as OrderFrom

FROM [lib://QVD/SalesOrderHeader.qvd]
(qvd);

Inner Join

Table2:
LOAD
BusinessEntityID,
TerritoryID
FROM [lib://QVD/SalesTerritoryHistory.qvd]
(qvd)

where Exists(TerritoryID,TerritoryID);

Inner Join

Table3:

LOAD
EmployeeBusinessEntityID,
IF(EmployeeBusinessEntityID>273 AND OnlineOrderFlag=0,EmergencyContactName,OrderFrom) as ListForSalesResp
FROM [lib://QVD/Employee.qvd]
(qvd)
Where Exists(BusinessEntityID,EmployeeBusinessEntityID);

Hi, PFA qvw file with 3 fields and 3 text boxes. I need to hide show these text boxes when field values are selected, but if the last selection is on 2nd field only 2nd text box should be shown the other two should be hidden.  Like i have FieldA, FieldR, FieldT with respective text boxes. When i select a value in FieldR, R text box should show, if i select FieldA, FieldA text box should show and R textbox should be hidden and so on. So this is based on last selection made on specific field. 

Any help much appreciate it. 

@sunny_talwar @swuehl 

Hey guys,

I have a table like this: 

I want in to result as such:

Based on the top number of orders per region. So Office B has the most orders in Region 1 and so on.

I really want this as a dimension though since I want to use it for coloring a map later on and I have better possibilities when I use a dimenson

Hi,

My bundle load script is not working properly. My script is

Bundle

LOAD PlayerId,

          Image

FROM

D:\Qlikview\DataSource\Data.xlsx

(ooxml, embedded labels, table is Sheet3);

Image Column is Path of Image Store location.

When i reload this script Only PlayerId column will reloaded but image column is not.

- Regards,

Vishal Waghole

Hi,

In my data model I have a date filed. I am using date Island to  and compare against the date in my data model. Using 'IF' I am getting desired results.  I need to compare two more conditions  in my expressions to calculate sums. Use if is slowing down all the calculations. I am trying to see if I can use set expression with date Island.

The expression I am currently using is

sum(if([Date]=IslandDate,Type ='Dispute',ChkFlag='Yes',1)) . Can I obtain the same with set expressions.

Any help would be highly appreciated.