Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Submit questions to product experts and participate in conversations.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Hi All
I have Updated_Date column and I need to create Month column based on the date column.
Updated_date | Completed |
5/2/2022 | 10 |
5/9/2022 | 15 |
5/16/2022 | 20 |
5/23/2022 | 25 |
5/30/2022 | 30 |
6/6/2022 | 35 |
6/13/2022 | 40 |
6/20/2022 | 45 |
6/27/2022 | 50 |
Requirement like I need to create a "Month_A1" column with last date in the month which is available in Updated_date column for example "Month_A1"
Base on Updated_date column I need to create Month_A1
in Month_A1 fields like
Month_A1 |
May-2022 |
Jun-2022 |
Final results be like
Updated_date | Completed | Month_A1 |
5/2/2022 | 10 | |
5/9/2022 | 15 | |
5/16/2022 | 20 | |
5/23/2022 | 25 | |
5/30/2022 | 30 | May-2022 |
6/6/2022 | 35 | |
6/13/2022 | 40 | |
6/20/2022 | 45 | |
6/27/2022 | 50 | Jun-2022 |
If I select May-2022 in Month_A1 column I need to see only "Completed" as 30
I need this month column created in Script and in front end filter as well.
Thanks in advance.
Hello Everyone,
I want to create a single filter XYZ in the script. This will act like conditional button for different conditional charts.
chart 1: Show employee name
— If the filter XYZ is ‘YES’ then show the names of employees whose name length is more then 9 characters
— if the filter XYZ is ‘NO’ then show the names less than 9 characters
chart 2: Show employee salary
— if the same filter XYZ is selected ‘YES’ this chart should show all the salaries which are more than 50000
– if the same filter XYZ is selected ‘NO’ the same chart should show less than 50000
chart 3: Show employee city
— if filter XYZ is ‘YES’ this chart should cities names starting with A,B,C
— if filter XYZ is ‘NO’ this chart should show cities with D,E,F
chart 4: show employee date of joining
— if filter XYZ is ‘YES’ this chart should show dates before 2019
— if the filter XYZ is ‘NO’ this chart should show dates after 2019
Hello everyone,
I have been working on this problem for a few days now with no luck and hence reaching out to you all here. I have a bar chart with the bar measure as:
Count(distinct {<[ProductCode]-={'Finance Spread'},[leasetype]={'L'}>+<[ProductCode]={'Finance Spread'},[leasetype]={'P'}>+<[ProductCode]-={'Finance Spread'},[leasetype]={'P'}>}[dealno])
This results in the following chart
The issue is if I Select 'VSC' from the filter, 'Finance spread' Still stays in the selection.
To solve this, I tried to change the measure to (Added the '$' sign):
Count(distinct $ {<[ProductCode]-={'Finance Spread'},[leasetype]={'L'}>+<[ProductCode]={'Finance Spread'},[leasetype]={'P'}>+<[ProductCode]-={'Finance Spread'},[leasetype]={'P'}>}[dealno])
Now this shows the correct selection but gives me the wrong count.
Is there any other way I could do this and get the correct count and selection?
Any help is highly appreciated.
Thank you!
I am trying to replace an number within a data set but only when it meets a certain criteria. I am having to use 2 separate tables as the data is stored in independent areas.
My script example is as below:
Test:
Load
JobNo
JobRef
JobStart
From 1st QVD
outer join
Load
JobNo
CompanyCode
From 2nd QVD
Jointable:
Load
If(WildMatch(JobRef,'*ABC*'),Replace(CompanyCode,'126','134'),
If(WildMatch(JobRef,'*XYZ*'),Replace(CompanyCode,'126','125'),CompanyCode)) as NewCode
Resident TEST
I am trying to replace the codes where the job ref meets criteria of containing a value as these have been miss assigned but with a consistency in the ref allowing me to identify which need to go where.
When I run this and filter for job ref it returns every Code instead of just replacing the one one code.
Hello Experts,
I have a calulated dimension as below which I wanted to sort in a particular sort order
Expression :
=if( aggr(sum(Sales),Admin_ID)/1000000>=100 and aggr(sum(Sales),Admin_ID)/1000000<=500,'100M - 500M',
IF(aggr(sum(Sales),Admin_ID)/1000000>=50 and aggr(sum(Sales),Admin_ID)/1000000<100,'50M-99.9M',
IF(aggr(sum(Sales),Admin_ID)/1000000>=25 and aggr(sum(Sales),Admin_ID)/1000000<50,'25M-49.9M',
IF(aggr(sum(Sales),Admin_ID)/1000000>=10 and aggr(sum(Sales),Admin_ID)/1000000<25,'10M-24.9M')
)
)
)
Sort otder I want is same as in Expression, but not sure how to write an expression for sorting.
Thanks in advance.
Hi,
I have a problem with license monitor application.
When I reload it, I get this error:
ERROR: No license usage data found. Reload aborted. Please verify that the following data connections are correct: ArchivedLogsFolder, ServerLogFolder.
The connection string for ArchivedLogsFolder are:
\\<FQDN>\<QlikShare>\ArchivedLogs
The connection string for ServerLogFolder are:
C:\ProgramData\Qlik\Sense\Log\
How can I fix it?
The version is Qlik Sense November 2020 Patch 6 - 13.102.13
We would like to automate the adding of endpoints to Qlik Replicate without having to use the GUI. The automation is required to be non-interactive since it will run from a batch scheduler. I am aware that tasks can be imported outside of the GUI (via the JSON files) but cannot see how to create endpoints via an import.
Is it possible to do this ?
Thanks
PC
Hi colleagues,
Please help with Filter codes.
I need to do a filter pane check:
If Filter is not chosen, show sum on Key pane.
I mean, I have filter with dates (years and days).
And I have a Key pane with Clients sum.
And i can't make that if filter is not chosen, Key pane must show “-” symbol, or something like “chose a period”.
Please help to realize the code.
Thanks a lot 🙂
Hola,
Tengo un set de datos que se ve así:
ID | DATE 1 | DATE 2 |
A | 1 | 3 |
B | 2 | 7 |
C | 3 | 4 |
D | 4 | 5 |
Donde el date1 es el día en el que un cliente entra al negocio y el date2 es el día en el que sale.
Quiero obtener la entrada de clientes neta por día (clientes que entrar menos los que salen).
De momento tengo estos dos gráficos:
Dimension: Date 1
Medida: count(id)
Dimension: DATE 2
Medida: count(id)
Lo que quiero es obtener la resta de lo que se muestra en estos dos gráficos, pero no se como debería programar la medida o dimensión ya que ambos tienen la misma medida pero diferentes dimensiones.
Gracias de antemano!!!
Hello Qlik Geeks,
I want to merge blank/empty values of a field RI to 'N' . I am using the below script to do that and it is not working. May I know what am i missing here ? Thank you in Advance
If(Isnull(RI), 'N', RI) as RI
Thank you,
CVR
MVP
23053Employee
8909MVP
8730MVP
8302Partner
8003Employee
6571MVP & Luminary
5850MVP
5399MVP
4777Employee
4004Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Subscribe to our Events and Webinar page so you do not miss an event opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!