Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.
Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.
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.
Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.
Hear directly from Qlik employees in our nine unique blogs. Check out the new Customer Success Blog!
Find a forum to ask a question or start a discussion.
Discussion Boards and Documents for Qlik Services.
Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.
Discussion board and documents related to Qlik Associative Big Data Index.
Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.
Hi All ,
In QlikSense Map ,
Dimension : Country
Colors by Measure : Euro value .
I see that instead of (,) for cents i see (.) which gives a different meaning .
I try to change the settings (like euro denomination ) i dont see it .Any idea to overcome this ?
Regards,
Uma
Good day,
I would like to modify a macro to send a straight table data to a excel file rather than a csv file. The original, csv export has been working for a few years from what I can see.
In the below macro, the portion of the macro that creates the excel file in the correct folder works perfectly.
The problem comes in when I want to Quit QlikView (ActiveDocument.GetApplication.Quit). When I un-comment that statement and run the macro, the excel file is created but then QlikView hangs with the below error.
I appreciate your assistance with this. Thank you in advance.
sub Reorder_Report
'Reading the file save path:
set v = ActiveDocument.Variables("vPath")
vPath = v.GetContent.String
'Define the file name:
set v = ActiveDocument.Variables("vFileName")
vFileName = v.GetContent.String
'Add the reload timestamp:
SET v = ActiveDocument.Variables("vfiledate")
varDate = v.GetContent.STRING
'Initialize Excel object:
set XLApp = CreateObject("Excel.Application")
XLApp.Visible = true
'Add a Workbook to Excel file:
set XLDoc = XLApp.Workbooks.Add
set XLSheet = XLDoc.Worksheets(1)
XLSheet.Activate
set table=ActiveDocument.GetSheetObject("CH04")
'Copy content of this object:
table.CopyTableToClipboard true
'And paste into Excel
XLSheet.Paste
XLSheet.Name = "Re-Order Report"
set XLSheet = XLDoc.Worksheets(1)
XLSheet.Activate
'Define a Range for which formatting will happen
set TitleRange = XLSheet.Range("A1:P1")
TitleRange.Font.Size = 12
TitleRange.RowHeight = 20
set DataRange = XLSheet.Range("A2:P300")
DataRange.Font.Size = 10
DataRange.RowHeight = 15
Const xlCenter = -4108
TitleRange.HorizontalAlignment = xlCenter
TitleRange.VerticalAlignment = xlCenter
XLSheet.Range("A1").Select
XLDoc.SaveAs vPath+vFileName+varDate
XLDoc.close
XLApp.Quit
' Up to here the xlsx file is created in the folder
' As soon as I un-comment the below Quit, QV hangs.
' ActiveDocument.GetApplication.Quit
end sub
Hi all,
Which is the best object for creating freeze panes ? I am using straight table but my selection functionality is not working properly.
For Ex:
id . name . country . ship to
23 rob us 23456
23 bob ca 23456
24 jack us 4560
here is what i am doing
i want freeze only 1st field so i have given that field in dimension and remaining fields in expression ,but when i am selecting 23456(ship to) it should show 2 rows right but it is just showing the row in which ship to is selected i.e means 1st row .
Can any one help to figure this out?
Thanks in advance
i would like to create a master dimension that is a list of customers excluding customers with the last name 'SHOPPER'.
what expression should i use?
thanks.
john doub
Hi Community,
I have a data like below from there I need values only if Seq is 1,2,3,4,5, not others. In the below example this seq is 2 times only .
Seq | Value | OriginalSeq |
1 | 10 | 1 |
2 | 15 | 2 |
3 | 20 | 3 |
4 | 25 | 4 |
5 | 30 | 5 |
5 | 35 | 6 |
6 | 40 | 7 |
7 | 45 | 8 |
1 | 50 | 9 |
2 | 55 | 10 |
3 | 60 | 11 |
4 | 65 | 12 |
1 | 70 | 13 |
2 | 75 | 14 |
3 | 80 | 15 |
4 | 85 | 16 |
5 | 90 | 17 |
Hi,
Why the following SCRITP code is FAILING in this "IF" FUNCTION,
IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1
ERROR: Invalidad Expression
That IF function is located at the bottom.
Conversion_rates_mapping:
Mapping LOAD
Action,
Conver_rate
FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is CONVERSION_RATES);
[DATE_PRODUCTION]:
LOAD
"Date",
Action,
Production,
Production *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED
FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is DATE_PRODUCTION);
[DATE_PRODUCTION_3]:
NoConcatenate
LOAD
"Date",
IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1
Conversion_rates_mapping:
Mapping LOAD
Action,
Conver_rate
FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is CONVERSION_RATES);
[DATE_PRODUCTION]:
LOAD
"Date",
Action,
Production,
Production *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED
FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is DATE_PRODUCTION);
[DATE_PRODUCTION_3]:
NoConcatenate
LOAD
"Date",
IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1
Resident [DATE_PRODUCTION];
Resident [DATE_PRODUCTION];
We have year wise Contract Share% for 2018,2019. How to display the constant Contract Share % per year across the dimensions and KPIs in a pivot table
Contract Share comes from an inline table in below format..
Share_Date | Share_Year | Share_Month | Plant | Carrier | Contract Share (%) |
and key has been created Share_Year&'_'&Share_Month&'_'&upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,
To Map the key in KPI table i.e. Year([Ship Date])&'_'&Month([Ship Date])&'_'& upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,
Below is the screenshot which is showing wrong values for Contract Share %. Need help in correcting
The actual Contract shares are below
2019 | ||
Catalao | ATRHOL | 50 |
Catalao | DICANALLI | 10 |
Catalao | DOLVITSCH | 10 |
Catalao | GEFCO | 5 |
Catalao | RODOMEU | 5 |
Catalao | SHOCK | 10 |
Catalao | TME | 10 |
Dear Experts ,
Please help me variance calculation for Fiscal year / Fiscal Qtr / Fiscal month wise dynamically for selected two year.
Test data and my QVW is attached for your reference.
Thanks a ton.
Best Regards,
Milind.
Hi All
How can I use the formula you giving in form of table.
Calc1 = Billed Revenue in Close Month [Jun only] / Total Billed Revenue of entire month [Jan-Dec]
I want to make
| Month | Calc1 |
| May | 0.289 |
| June | 0.301 |
im using expression below but the calc1 shows 0 and not showing any dimension in table.
Expression:
sum ({< OppForecast= {'1'},[SPM Close Month] = {'$(=Month([SPM Date]))'}>}[Est. Billed Revenue For Current Year])/ sum ({< OppForecast= {'1'},>}[Est. Billed Revenue For Current Year])
Dimension:
=Date([SPM Date],'MMM-YY')
MVP
22081MVP
8541Employee
8315MVP & Luminary
8138MVP & Luminary
7956Employee
6456MVP & Luminary
4825MVP
4788Employee
4171MVP & Luminary
4065Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.
This group hosts information related to the Qlik Deployment Framework (QDF).
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Get the most value from your data and see the hottest trends in data and analytics. Join us in Phoenix, AZ. Register by December 31 to save $400.
An exclusive online event where industry experts share practical advice to help your entire team take charge of their data.