Hi,

I am tying to make a chart that shows the top 5 most populous colleges in a certain state (Minnesota). I have a variable called [States], a variable called [College Name], and a variable called [College Population]. What script can I use to do this?

Thanks,

Dear Gurus, 

I have a situation, where each group of tables is owned by different divisions. This ownership is indicated by REDUCTION field in each tables. Section Access defines who has access to what tables.  

But to use REDUCTION field, we are bound to create such relation with security table (=Section Access table). 

But this will create such a datamart behind Qlik Sense. 

Once we needed to link-up with FKs (foreign keys), we end up with such. 

To the worse, these REDUCTION values are nothing to do with the business meanings: i.e. it completely destroy relational key (FK_1 and FK_2), by creating synthetic key. 

Now, Link Table is only effective if the model is simple and record numbers are small. If we take on 50-80 million distinct FKs with 2 FACTS + 8-12 DIM tables, Link Table should host all the combination of distinct values. This is no-go. 

In Qlik Sense, can we achieve "Table-Level Security" and FK relationships at the same time? (I doubt it.)

To elaborate this case more, here is the example. 

• You have Section Access, with USERID and REDUCTION. 
• FACT_SALES is owned by Sales team. 
• DIM_COA is owned by Finance team. 

Users are setup as such: 

• DOMAIN_USER_01 can access both tables. 
• DOMAIN_USER_02 is an accountant, and only have access to DIM_COA. 
• DIM_COA has one-to-many relationship to FACT_SALES. 

Now, we must implement user-access restriction based on table's REDUCTION, but still ensure the FK relationship. This results in such model, and no records is associatable. 

*This type of security can be easily implementable by the BI tool, that does credential passthrough to the base table.

In my opinion, there must be a compromise that:

• This type of security is not possible in Qlik Sense. 
• Alternative is to create a Reporting Datamart. Original security properties are overwritten by ETL, so that Security table and FACT table will handle security as single point. The rest of cascaded filtering can be slightly loose.

<This is the traditional Section Access, RLS>

I think this is still acceptable. Is DIM data so secret? Usually no. They would be mostly some type of product, market segment, department, customer ....etc. It is the FACT that has to be confidential. 

If DIM has PII (Personally Identifiable Information), create a special composite key, that effectively nullify via the FK if user is unauthorized. 

But first of all, I am grateful if you possibly advise me about your opinion/view because you are probably far more experienced than me, a Spark data engineer. Thanks for your help.

Estou tentando convencer as vantagens do QlikSense sobre o PowerDecision, e entre os argumentos que me apresentaram não existir no Qlik, é a facilidade de copiar o conteúdo de algumas tabelas no Qlik e colar numa única tabela Excel.

Este tem sido um ponto muito citado nas argumentações e não quero crer que o QlikSense não permita essa facilidade, talvez uma configuração que seja necessária ou versão específica.

Aguardo um retorno o mais breve possível para que possa juntar eventual retorno positivo a minha lista de argumentações.

Tengo una tabla con  eventos por sucursal y las fechas de las actividades, en otra tabla tengo las campañas, la agencia y el rango de fechas de la campaña y necesito agregar la campaña a la tabla de actividades y una tabla con ese dato incorporado. He probado con Join pero solo me combina las agencias con todas las campañas y no me toma las fechas

I'm trying to do a find and replace type of thing using the match function.

Why does this (in the Data Load Editor) break my map?

if(match(county, county = 'St. Mary' & chr(39) & 's'), 'Saint Mary' & chr(39) & 's') as Modified.county,

The map shows a message saying this:

[Modified.county] - Area Layer

The data contains invalid geometries that could not be shown on the map. Review your data for errors and try again.

Hi guys!

Following question because i think i go crazy.

I have a table with "reclamations" and this "reclamations" have different Date "Positions"

Some are notificated = we was informed that there is a problem, some are picked up from us from the customer, some are arrived our stock.

then there are timestamps when the customer is informed about costs and when for him its ok the date when gives us the ok.

start repair date, delivery etc.

All i want to have is a gantt with a timleine where i can mke this visible but i dont check it.

example for a line:

3 days from notification to pickup, 7 days from pickup to arrive our company, 15 days from inform the customer to his answer, 8 days for repair / production, 4 days from delivery stock to shippment.....

Has anybody an idea how i can solve this problem?

Thank you very much!

Dear Qlik Community,

Since last Tuesday, we have been getting the following error message in Chrome and Microsoft Edge when using the OnDemand feature for NPrinting.

An error occurred:
{"code":403, "message": "User has no rights to access the resource"}.

We had this error once in the past, but were able to resolve it with the help of the following post:
https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-Ondemand-not-working-on-Chrome/td-p/1682939

The error occurred suddenly without us changing anything in the application. Strangely enough, the OnDemnad function works in Internet Explorer.

Support has already been informed, but maybe someone from the community has had the same experience recently.

Already many thanks and best regards
Lennart

Hi Everyone,

Good Evening,

My source is jira, Loaded data from Jira through REST API into qlik sense, while loading Issue table custom fields are loading into Qlik like Custom filed ids as lable, so its difficult to identify what is the actual filed name from jira.

Due to requirement in project few field were added in Jira by Jira developer those fields called custom fields. These newly added fields by Jira developer are coming into qlik as custom filed with id (ex: custom field 250,custom filed 340).

While creating the REST connection defined the filed names in the parameters, even though custom filed with ids are loading.

Do i missed something while loading,please help on this.

Thanks in Advance!!!!!!!!!!!

Varsha.

Hello Folks,

I have a datamodel that has three tables.  On the UI side, I have a straight table showing the data.  What I would like to do is count the number of times a value in Field A does not appear in Field B.

For example, the data set below:

AllowedTerminals:
LOAD * Inline
[
    'Bill To Terminal', 'Order Bill To Id'
    'GSP', 'IBM',
    'CLT', 'IBM',
]
;

Orders:
LOAD * Inline
[
    'Order #', 'Order Bill To Id'
    '18CA7B', 'IBM'
    '63D95E', 'IBM',
]
;


Assets:
LOAD * Inline
[
    'Order #', 'Tractor', 'Tractor Terminal'
    '18CA7B', '123 Freightliner', 'GSP',
    '63D95E', '900 Mack', 'LAX'
]
;

EXIT Script
;

In the example above, the tractor used for Order #18CA7B is terminaled at GSP.  GSP exists in the [Bill To Terminal] field that is linked to the [Order Bill To Id] of IBM.

However, Order #63D95E used a tractor terminaled at LAX, and LAX is not in the [Bill To Terminal] list.

I'm trying to get something like the following where the field CrossTerminalCount reflects the number of times this has happened.

The only solution that I can think of revolves around using the P() function, but every time my mind has gone in that direction, I've always had to backtrack.

Any help is greatly appreciated.