Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Participate in Qlik Technical Previews, submit ideas, and review documentation.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Learn about upcoming Qlik related events, webinars and local meetups.
Hear directly from Qlik employees in our ten unique blogs.
Get started, find How-To documents, and join general non-product related discussions.
Here you will find a list of all the Qlik Community forums.
May 26, 2021: Choose the session of your choice
May 20, 2021 at 2PM EDT/11AM PDT
There is a brand-new area of the Qlik website designed to be your one-stop place for all information related to our product innovation and direction.
Be sure to visit and bookmark QLIK.COM/ROADMAP to stay informed about what’s new and what’s coming and learn more about our vision and strategic direction.
I have this script and it is not working.
LOAD * INLINE [
load * Resident tan
Where F1 > date('09/06/2021', 'MM/DD/YYYY');
DROP TABLE tan;
I was expecting the table 'tan1' to have only the first row but tan1 is not even getting created.
what is wrong with it?
i have 2 dates : date, business date
this is separate qvd with 2 dates
date business date
i have filter in my app that uses today’s date as overall filter on date field, but it has to pick up business date when todays date is not business date. Suggest me.
in my app
Where date= date(today ());
I currently have an excel dataset and am trying to transpose the data as shown below but in Qlikview. Any ideas on how this can be achieved would be greatly appreciated!
|Name||Go Karting||Date Completed||Scuba Dive||Date Completed||Zip line||Date Completed||Skydive||Date Completed|
I have the following table of fields as an example:
I want to split Field_2 into subfields by values of Field_1, like:
The end user can select from the new fields one value (as an example: A1,B1,C1).
Field_2 should highlight A1,B1,C1 (should recognize the choosen values from its subfields).
The end user can select now one or more than value from A1,B1,C1 in field_2.
Any help please?
Thanks in advance.
I'm getting an invalid expression error in this section, but I'm very new to this and don't know what I'm doing wrong. Please advise!
PROD_CD_GRP AS RATE_SERIES_AC,
'XXXXXXXXXX' AS SORCE_POLCY_ID,
AVG(UNITS) AS UNITS,
RIDER AS COVG_IND,
'' as ISSUE_ST,
'$(vYear)' as ENTRY_YEAR,
1 as ENTRY_MONTH,
1 as ENTRY_DAY,
((avg(ANNUAL_PREM))/(avg(UNITS))) AS ANN_PREM_PU,
'XXXXXXXX' AS ORG_BCN,
'XXXXXXXX' AS CURR_BCN,
12 AS PREM_FREQ,
SUM(INIT_COV_COUNT) AS INIT_POLS_IF,
IF(FAMILY_CD='0','1',FAMILY_CD) AS FAMILY_TYPE,
5 AS GTEE_PER_Y,
100 AS COVERAGE_TERM_AGE,
(sum(WOP_BENFT_AMNT))/(sum(UNITS)) AS WOP_BENFT_AMNT_PU,
IF(DEFAULT = 'Y', '190001', MAX(STAT_LKUP_ALR_MRTLY)) AS STAT_LKUP_ALR_MRTLY,
'' AS COHORT_CD,
'' AS INIT_DAC_EXPNS_VOL,
'' AS INIT_DAC_CMMSN_VOL
WHERE (ISSDATE >= STAT_LKUP_ALR_MRTLY AND ISSDATE <= STAT_MAX_ALR_MRTLY) OR DEFAULT = 'Y'
ORDER BY SPCode;
I learned by this forum that we could use
-= to do an exclusion in set analysis but when i try to use it with a or to make 2/3 excluding that doesn't work
if Someone could make me learn how to make work multiple excluding in set analysis ? 😛
Thanks a lot for reading 😛
I am unable to border my excel report in nprinting edit report template.
req is below :
I used the border when creating edit report template.
I am using master measures in Qlik Sense to create a bar chart and the master measure has a color applied. In Nprinting I am bringing this into a table object. The "Keep source format" is checked, however the color set in the Qlik Sense chart is not seen in the Nprinting chart. I want to be able to add expressions to set the color, as doing it manually is very cumbersome. If this is not possible, is there a syntax available to set the color when the "Keep source format" is unchecked?
Please let me know.
Our featured member for May 2021
Learn about what's new across all of the products in our growing Qlik product portfolio.
Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
German speaking - This group makes it easier to collaborate in your local language.
This group for Brazil users. All discussions are in Portuguese.
This is a open Group for the Public Sector
These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.
You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about QlikView.
This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.