Qlik.com | Qlik Help | Resources

Ask a Question

Welcome to
Qlik Community!

Recent Discussions

Sort By:

New to Qlik Analytics

Set hard filter for table, independent from selected value

I have a worksheet with multiple tables. example: The tables on the bottom have to be filtered by the filter 'team'. the table on the top has to be... Show More

I have a worksheet with multiple tables.

example:

The tables on the bottom have to be filtered by the filter 'team'.

the table on the top has to be filtered on a hard value, independent of what is selected in the filter in the blue square.

I created a filter for the upper table with the expression:

if(Team='Staf', Groep,)

which worked.

But then I created the lower 2 tables which do have to be filtered by the selected value in the blue square (only 1 selected possible). However, this changes the table on the top also.

I then thought: I create an alternate state for the table on the top so the selection in 'Team' doesn't affect this table, but I ended up with 'Team' being in the selection bar, showing 'selection in 2 states'.

I do not want selections in 2 states. I only want selections in 1 state.

How can I achieve this? Is it possible to have the top table filtered on a hard coded value and not being affected by any selection made in this variable AND the variable not having 'selections in 2 states' in the active selections bar? I want to be able to quickly change the selection of 'team' as I expect the user not to understand for which state the selection has to be changed.
Show Less

By DutchArjo 2024-05-15 / 06:29 AM

15 2 311
App Development

Dynamically Displaying 0 Data Date on Chart via rolling-N month window.

Hi All, Need some help with my current issueScreenshot of default look of data that I have What I'm trying to achieve. Is to be able to show Future D... Show More
Hi All,

Need some help with my current issue

Screenshot of default look of data that I have

What I'm trying to achieve. Is to be able to show Future Dates via selection of MonthYr to display running 12 months data based on vMaxMonth

I've Created a calculated table based off the data within my company's UAT server also Left Join another table to it based off the Master Cal attached Trade_count = 0 to MonthName.
```
TradeCount:
Load 	MonthName,
	order_contract_orderstatus 	AS Trade_Count_Status,
        OTC_FLAG 			AS T_OTC_FLAG,
        STP_FLAG			AS T_STP_FLAG,
	alt(count(ordercontractid),0) 	AS Trade_Count
Resident MVP1
Group by MonthName, order_contract_orderstatus, OTC_FLAG, STP_FLAG
Order by MonthName desc;

LEFT JOIN(TradeCount)

Future_Data:
Load  MonthName,
      0 As Trade_Count	
Resident Master_Cal;
```
To get the table below
```
NoConcatenate
Final_Trade_Count:
Load	MonthName,
	Trade_Count_Status,
        T_OTC_FLAG,
        T_STP_FLAG,
	Trade_Count 
Resident TradeCount;
Drop Table TradeCount;
```
Where the table look some what like this

Current Dynamic Rolling-N Month Chart script looks like this.

alt(Sum( {1<Trade_Count_Status={'Settled'}, Date ={">=$(=Date(AddMonths(vMaxMonth,-11),'DD/MM/YYYY')) <=$(=Date(AddMonths(vMaxMonth,0),'DD/MM/YYYY'))"}>} Trade_Count),sum({1< Date ={">=$(=Date(AddMonths(vMaxMonth,-11),'DD/MM/YYYY')) <=$(=Date(AddMonths(vMaxMonth,0),'DD/MM/YYYY'))"}>} 0))

vMaxMonth =Date(max(order_contract_tradedate),'DD/MM/YYYY')

When ever i select a MnthYr be it future or past data i get the following output:
Instead of showing me 12 month rolling period with 0 date Data showing and past month showing, nothing is being displayed.

Please Help.
As I'm on enterprise QS I cant share qvf due to security issues.
Show Less
By Keitaru 2024-06-05 / 02:30 AM

1 0 10
Qlik Gold Client

GoldClient performance - STXL

Hello, When trying to extract data type CA - Orders Master (AUFK), the extract takes a very long time. Looking in SM51, it appears the process is taki... Show More

Hello,

When trying to extract data type CA - Orders Master (AUFK), the extract takes a very long time. Looking in SM51, it appears the process is taking a long time reading table STXL.

How can the performance be improved?

Alternatively, can this read be skipped?

Thank you,

Adrian
Show Less

By Adrian_Tuhtan 2023-02-28 / 02:04 PM

6 0 840
New to Qlik Analytics

multiple where condition

hi, would like to do a: load* resident [table] where [FIELD 1 contains 'Yes'] and where [FIELD 2 contains 'team'] how would i do this in the load... Show More

hi,

would like to do a:

load*

resident [table] where [FIELD 1 contains 'Yes'] and where [FIELD 2 contains 'team']

how would i do this in the load editor?
Show Less

By nickmarlborough 2024-06-05 / 01:49 AM

2 0 40
New to Qlik Analytics

Relative numbers based on dimension limitation

Hi, I am trying to create a table to display the values of the top 20 selling items and I have a measure that is going to calculate the sales as share... Show More

Hi, I am trying to create a table to display the values of the top 20 selling items and I have a measure that is going to calculate the sales as share per total or sales ratio, let's say I have a total of 30 items and I only want to show the statistics for the top 20 items, I've set a limitation of 20 for my dimension and set the measure modifier to 'Relative Numbers', I've also tried this expression 'SUM(Sales) / SUM(TOTAL Sales)'. However, I realized that the returned values are in relative to all the 30 items instead of the 20 items that are limited in the dimension.

Below is an example of what I need:
Exp Sales Table:
Product | Sales
A | 30
B | 10
C | 25
D | 25
E | 10

Let say I want the stats for the top 3 selling product, it should have figures as table below:
Product | Sales | Sales%
A | 30 | 30/(30+25+25) = 37.5%
C | 25 | 25/(30+25+25) = 31.25%
D | 25 | 25/(30+25+25) = 31.25%

But instead, I am getting figures as below:
Product | Sales | Sales%
A | 30 | 30/(30+25+25+10+10) = 30.00%
C | 25 | 25/(30+25+25+10+10) = 25.00%
D | 25 | 25/(30+25+25+10+10) = 25.00%

How can I get the relative value of the limited 20 items or is there a workaround for this? Any help is appreciated!
Show Less

By poklegoguy 2024-06-04 / 08:08 PM

3 0 85
Security & Governance

Permissions for qlik-365-connector

Hi, Our organisation is concerned about the default permissions requested by the qlik-365-connector. What is the bare minimum required to be able to s... Show More

Hi,

Our organisation is concerned about the default permissions requested by the qlik-365-connector. What is the bare minimum required to be able to send e-mails from Qlik via Microsoft 365 using delegated permissions?
Show Less

By JakSSK 2024-06-05 / 02:20 AM

0 0 16
Qlik Application Automation

Error REP-500109 on generate report block

Hi, I've build an automation to create reports and send it by mail. I have a list variable with 7 values. I use a loop to go through this list, stor... Show More

Hi,

I've build an automation to create reports and send it by mail.

I have a list variable with 7 values. I use a loop to go through this list, store the current value in a variable and use it to create a report with a selection equals to the value store in the variable. Then I generate the report.

The automation and loop work correctly exept the fact I randomly have an error on the generate report block.

I say randomly because if I run the automation twice, the error will be on a different value of the loop.

An idea of what is this error and how to fix it ?

Thanks,

Amélie
Show Less

By AmelieF 2024-06-05 / 02:18 AM

0 0 13
Francophones

Filtrer table sur valeurs ‘-‘

Bonjour, Sur une table je souhaite afficher uniquement les colonnes dont les valeurs sont ‘-‘ sur 2 colonnes (dans l’exemple ‘PA creation date’ et ‘in... Show More

Bonjour,

Sur une table je souhaite afficher uniquement les colonnes dont les valeurs sont ‘-‘ sur 2 colonnes (dans l’exemple ‘PA creation date’ et ‘indice’ soit 5 lignes doivent être affiché).

Dois je créer dans un premier temp une colonne dérivée qui permet d’afficher une valeur nulle et non ‘-‘ ?

Comment filtrer ensuite dans la table, j’ai essayé des expressions dans le champ de colonne (fx) mais je n’arrive pas au résultat souhaité.

Merci beaucoup.

Show Less

By Cyrilio 2024-06-05 / 01:04 AM

1 0 41
Deployment

generationManager is not initialized by the perljet/javajet! in github ci

Hello dear all.I've just migrated my Talend Cloud v8 from Patch 2023_09 to 2024_02.It works well on the studio side, but when I run my CI tasks in git... Show More

Hello dear all.

I've just migrated my Talend Cloud v8 from Patch 2023_09 to 2024_02.
It works well on the studio side, but when I run my CI tasks in github action I faced this issue, while it ran perfectly before the migration :

[INFO] exception : org.talend.commandline.client.command.CommandStatusWrapException: java.lang.RuntimeException: org.talend.designer.runprocess.ProcessorException: org.talend.commons.exception.PersistenceException: java.lang.IllegalStateException: generationManager is not initialized by the perljet/javajet!

For further informations, I'm using this commandline :

mvn org.talend.ci:builder-maven-plugin:8.0.13:executeScript -Dinstaller.clean=true --batch-mode --debug --errors --settings ${SETTINGS_FILE} -Dgoal=generateAllPoms -DscriptFile=${GITHUB_WORKSPACE}/app/buildJob.txt -DprojectFilter=EHR_IMPORTS -Dproject.build.sourceEncoding=UTF-8 -Duser.timezone="Europe/Paris" -Dlicense.path=${LICENSE_FILE} -Dtalend.studio.p2.base=${P2_PATH} -Dtalend.studio.p2.update=${PATCH_PATH}

where buildJob.txt =
setUserComponentPath -up /runner/_work/ehr-imports/ehr-imports/app/EHR_IMPORTS/components
buildJob MY_JOB_NAME -dd /runner/_work/ehr-imports/ehr-imports -af MY_JOB_NAME

Note that, sometines (something like 1 time for 1000) the build work well.
Second note, When I use the command executeJob, it work well !

Thank you in advance for any help

Show Less

By FGoasmat1638462303 2024-06-04 / 01:20 AM

1 0 42
New to Qlik Analytics

Compare selected date range in date picker with previous dates

Hello, we'd like to compare dates we select in a date picker with the previous dates of this exact selected amount of days. So if we select an interva... Show More

Hello,

we'd like to compare dates we select in a date picker with the previous dates of this exact selected amount of days.

So if we select an interval of 3 days to compare, we would like to compare these to the 3 days prior to these.

e.g.

We select the following dates:

12/02/2024
13/02/2024
14/02/2024

and want to compare these data to:

11/02/2024
10/02/2024
09/02/2024

Another example:

20/03/2024
21/03/2024
22/03/2024
23/03/2024

compare to:

19/02/2024
18/02/2024
17/02/2024
16/02/2024

Is this possible?
Show Less

By magellan 2024-06-05 / 12:52 AM

1 0 33

High Five

Meet Théo

Our featured member for June 2024

Leaderboard

igoralcantara

Heinvandenheuvel

marksouzacosta

Lech_Miszkiewicz

andreykh

marcus_sommer

Popular Resources

View All

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.