Community

New to QlikView

Discussion board where members can get started with QlikView.

Inputting an excel table with multiple headers

by on Latest post by

4 Replies 141 Views

4 Replies

141 Views

Macro to merge cells doesn't work

by on Latest post on by

1 Reply 36 Views

1 Reply

36 Views

How to export two tables at the same time to Excel...

by on Latest post on by

4 Replies 100 Views

4 Replies

100 Views

Number Format for a calculated field in script

by on Latest post on by

1 Reply 77 Views

1 Reply

77 Views

Loading multiple excel files and sheets not workin...

by on Latest post on by

5 Replies 231 Views

5 Replies

231 Views

Labels

"error" 1
'data model' 1
.shared file issue 1
3quarters 1
4-4-5 1
443 1
80th Percentile calculation 1
@rwunderlich @marcus_sommer @Oleg_Troyansky 1
@sunny_talwar 4
a 1
above 3
Access denied 2
Access Null data Values in qlikview 1
Access Point 4
Access-point 1
accesspoint 3
Accumulation 3
Accuracy 1
Actions 2
activate object 1
ad hoc report 1
Adding previous rows values in pivot of qlikview 1
Addmonths 1
advanced set analysis 1
aggr 9
aggr function 1
Aggr or Set Analysis 1
AGGR() 9
aggregate 7
aggregating seconds field into hour field 1
aggregation 5
Ajax 2
Ajax Accesspoint 1
alert 1
alert qlikview 1
Alert wizard 1
alerts 1
aligment 1
align 1
alphabetical 1
Alternate States 8
alternative measure 1
Alternative state 1
always_one_selectedalways_one_selected_valuefrom_and_to_weeklist_boxesoptionpropertiesset_analysisvariableweek_analisys 2
Analysis 3
Anaplan 1
and 3
angle brackets 1
Animated scatter chart 1
App Design 1
App Development 4
App Size 1
Apply 1
applymap 1
Applymap() 1
arbitrary 1
ARPITWIZ 1
arrg 1
Association 1
Athena 1
auto-converting data type 1
autocomplete 1
autofit screen 1
Automation 1
autoscaling 1
average 5
Average Metric Calcualtion 1
avg 2
avg() 1
AWS 3
axis 1
axis color 1
Azure 1
background 1
background color 1
bar 3
bar chart 20
bar chart expressions 3
Bar charts 1
barchart 7
BarLegendOverlapping 1
base 16 format 1
BasesDeDatos 1
beginner 1
billed 1
blank 1
Blob_to_Text 1
block chart 1
blog 1
bold 1
BOM 1
Bookmarks 1
borders 1
Boton 1
bottom 1
bracket v12 1
Business Analyst 1
button 1
Button to select Cases 1
buttons 3
Cache 1
calculate 1
Calculated dimension 3
calculated dimensions 3
calculated field 2
calculation 4
Calculation based total amount find the Usage 1
Calculation Condision 1
Calculation Condition 1
calculations 1
calendar 5
Call 1
Cals 1
Campo 1
can't open qvw 1
Canonical Date 1
caracteres especiais 1
Carga de arquivo QVD para consulta de arquivos de BI 1
cartesian 2
case 1
Case Statment in list box 1
Case Study 1
CAST 1
cell 2
cell format 1
cells 2
cellvalue 1
centralization 1
certification 2
chart 10
Chart bar 3
chart expressions 2
ChartOverlapping 1
charts 5
check 1
check file exists 1
Checkbox 1
Chess 1
clear 1
clear fields 1
Clear one selected field value based on variable selection 1
clear state 1
ClearAllTrigger 1
Cláusula 1
coding 1
Color 5
color change 1
ColorMix 1
Colors 1
colour 1
column 5
column order 2
columns 2
columns change 1
colur 1
Combine fields 5
combined chart 1
combo 1
Combo Chart 3
comma separated 1
comment 3
Comparation 1
compare 4
compare fields script 1
comparison 1
comparitive analysis 1
composite key 1
Compute 1
Concat 5
concatenate 12
condition 1
conditional 1
conditional dimension 1
conditional display 1
conditional expression 1
Conditional formatting 2
conditional load 2
conditional show 2
conditional sum 1
ConditionalExpressions 5
Conditions 1
conector web 1
config 1
configuration 1
connection 1
connections 1
Connectivity 1
consecutive differences 1
CONSISTENT 1
consolidate 1
consumption 1
container 1
containers 1
contar 1
Convert field value which starts with text or some special characters into 'NLL' 2
Convert Qlikview obj to json 1
converttolocaltime 1
Cookies 1
Count 13
count distinct 1
Count if 3
Count if condition 2
COUNT Parameters 11
COUNT UNIQUE OCCURENCE 1
Count with If condition 2
countrecords 1
Create Line chart by using data as how many times user visit on website 1
creating table 1
Cross Table 3
crosstable 1
Crosstable does not help 1
Crosstable multiple rows 2
csv 3
cumulative 3
cumulative % 1
Cumulative sum in straight table 1
Cumulative summation by date 3
Currency 1
CURRENT TIMESTAMP 1
currentfieldexpression 1
currentfieldselected 1
custom 1
Custom error messages 1
custom sort 1
custom sorting 1
Customization 1
cyclic dimension 1
cyclic group 1
Cyclicgroupexpression 1
Dashboard 7
dashboard issues 2
data 12
Data Catalog 1
data cleansing 1
data comparison 1
data connector 1
data converting 1
Data Dictionary 1
data governance 2
data load 1
Data load editor 2
data loading 2
data mapping 1
data minima 1
Data Model 2
Data Modelling 3
data science 1
data storing 1
data transformation 1
data type 1
database 1
Database Update 1
databetweentwodates 1
Datamodel 3
Datamodel should get refresh data on every reload 1
Datasource 1
Date 31
Date Bucket 3
date comparison 2
date convert 1
Date converting 1
date field 2
Date filter 2
date format 5
date formatting 1
Date Order 1
Date Range 6
Date time 1
DATE VALUE 11
Date Variable 1
DateFormat 1
dates 6
dates comparison 2
datetime 1
DateTimeformat 2
datos 1
days input 1
days past date calculation 1
decimals 3
default mapping 1
defaults 1
delay 1
Delete 1
delimiter 1
Deployment 2
design 4
detach 1
Detailed Drill Down 1
Development 3
deviation 1
difference 1
different granularity 1
dim 1
dimension 6
Dimension ascending of Fiscalyearquarter 1
Dimension axes 1
Dimension labels 1
dimension limit 1
DimensionLimit 1
Dimensions 18
Dimensão 1
dimesions 1
Distinct 1
Distinct List 1
Distinct values 4
distribution plot 1
do not show null 1
Document Chain 1
Document chaining In Qlikview 2
Documentation 1
DOD 1
Dollarexpression 2
Doughnut 1
Download 1
drill down 1
drop box 1
duplicate 1
Duplicaterecords 2
duplicates 3
dynamic 1
Dynamic Charts 1
dynamic dimension 1
dynamic dimension limits 1
Dynamic selections 1
dynamic table 1
DynamicColumns 1
easy 1
EC2 2
EffectiveDate. 1
else 1
email 1
emojis 1
empty bars 1
Enable Conditional 1
End 1
enddate 1
endif 1
Error 3
error expresión utilizando signo > 1
Error Load in Qlikview November 2018 2
Error Loading fies 1
Error Messages 1
ETL 1
Events 1
excel 5
Excel data 7
Excel data sets to Qlik 1
Excel Exports 2
excel worksheets 1
exclude 1
excluded 1
Excluded Values 3
ExcludedValues 1
exclusion 1
executable 1
Execute Command in Script 1
exists 1
export 5
export data 2
Exporting data 1
exporting multiple tables from QV to Excel 1
expresion 1
Expression 45
expression editor 1
Expression Error 8
expression syntax 1
Expression Total 1
ExpressionColors 1
Expressions 15
expressions straight table 5
Failed to open document for unknown reasons 1
field 3
Field Event Trigger 1
Field name 1
field not found 1
Field renaming 1
field selection 1
fields 1
fieldselection 1
File wizard: Transform 1
files 5
Filter 14
Filter by Data Types 1
Filter Date 1
Filter Dates 2
Filter dimension measure 1
Filter only on some data 1
Filter Visualization 1
filtering 1
filters 1
Firewall 1
first day 1
FirstSortedValue 2
fiscal year 1
FIXED DIVISION 1
flag 2
floor 1
folder 2
font 2
fonts 1
for 1
for loop 3
Force selections 1
Forecast 2
format 4
format num 1
Format Specification Item 1
Formating 1
formatting 1
Formatting Rules 1
formula 2
Formula working in Text Box but not in Pivot Table 1
Fractile Aggr Linest_b Linest_m Trendline 1
front-end 1
FTP 1
Fuzzy search 1
Gantt chart 1
gauge 2
gauge chart 1
gauges chart 1
Generate dates 1
Generic calendar 1
generic key 1
generic load 1
Generic Load. 1
get percentage 1
GetFieldSelections 5
GetSelectedCount 2
Getting Started 1
Governance 1
governance dashboard 3
Graph 3
graphics 2
Graphs 2
Greentree 1
Grid chart 1
group 2
group by 4
Groups 1
has error bar 1
having count 1
help 5
help needed 1
hiddenscript 1
hide 2
Hide and show 3
hide Listbox 1
HideExpression 1
hiding 1
HidingExpressions 1
hierarchy 2
Histogram 1
holding page 1
HolidayList 1
Holidays 1
horizontal 1
hours 1
How to assign same values to Nulls which is having primary key in Qlikview script while loading 1
How to develop an Application in the QlikView to send the SMS using VB Macro 1
How to get the last used report date for NL user in QV 1
How to show Average of Rows in Pivot Table 1
HTML 2
HTTP 1
https 1
https redirect 1
Hypertext 1
if 11
IF & OR 3
IF AND STATEMENT 3
if clause 3
If else 2
if else statment in list box 1
if expression 1
IF only 1
if statement 10
if-sum 1
If...ElseIf 1
If...ElseIf cause 1
ifthenelse 1
ignoring selections 1
image 1
Images 1
Important 1
inbetween 1
inc load 1
IncludedValuesfirst 1
Incremental Load 6
IncrementalLoad 1
IncrementalLoadwithoutdatefield 1
indepenant selections 1
independant sheets 1
independent field 1
indexing 1
Inline Load 1
input 1
input box 2
input box objects 1
inputbox 1
inputfield 2
Insert 2
InsertUpdate 1
Integration 1
IntervalMatch 1
IntervalMatch on multiple fields with multiple condition in a table 2
Intervals 2
Intervel call 1
invalid dimension 1
Invalid expression 1
ipl 1
Island calender 1
IsNull() 4
iterno 1
jagan 1
JD Edwards 1
JIVE 1
johnw 1
join 12
Join Query 5
Jontydkpi 1
JSON 2
karl pover 1
keep all possible values 1
keyfield 1
KPI 2
kpi's 2
kpis 1
label 1
Last 3 years in SET analysis Issue and selections also should include 1
last day 1
last year 1
Lastyeardata 2
latest 1
latest balance 1
launch 1
left join 2
LegentOverlapping 1
Lentidão Carga Qlikview x Nuvem 1
less than 1
Licence 1
licence management 1
License 1
license update 1
limits 1
line chart 4
Line Chart Missing Data 1
line-chart 1
LineChartExpression 3
Link 2
Link Table 1
linkage 1
linking 1
list 1
list box 6
List Box Range Values 1
Listbox 11
Listioffields 1
load 7
load .dat file in Qlik Sense 1
load all files in folder 1
Load Data 7
Load Data distinct 1
load error 1
load file greater than date 1
Load last 3 years Data from Sql Select 1
Load Script 15
LOAD SCRIPT CONSUMPTION TABLE 1
Load Script Error 1
loading 1
loading data 1
Log Files 2
logic 2
Lookandextract 1
lookup 1
Loop 3
ly 2
LYSales 1
Macro 12
Macro export 3
macro-building 1
macros 4
makedate 2
Management 1
Management Setup 1
manual 1
Mapping 3
Mapping files 1
mapping table 1
Mapping() 2
mappingload 1
Maps 1
master calendar 6
Mastering QlikView Data Visualization 1
MAT 1
Match 10
Match field value 1
mato32188 1
max 1
max date 2
Max Date Value 2
Max del día y hora 1
Max Function 6
max value 1
Max value next column 2
MaxDate 1
MaxString 2
MB 1
mbytes 1
measures 1
Medain 1
Median Calculation 1
Meeting 1
Memoria 1
Memory 2
merge 1
mergecells 1
Merging-joining Data from different fields into 1 field 1
Metadata 1
Microsoft Power BI 1
migrating servers 1
Migration 1
Min 1
min value 1
MIN_MAX_AVG 1
MinDate 1
minimum 1
minimum value 2
minus 1
Missing Data 4
missing records 1
Missing Target values 1
Missing Value 1
missing X-Frame-Options & Content-Type header 1
Mixed dates 1
mock test 1
MOM 1
month 8
month year 1
Monthly Snapshot of Data without date and key 1
MonthName 3
Moving Average 2
MTD 5
Multibox 1
Multiboxfilter 1
MultidimensionChart 1
multiple conditions 1
Multiple Datasets 1
multiple dimensions 1
Multiple fields 1
multiple files 2
multiple tables export 1
Multiple text 1
multiple values 1
mutations 1
N 1
n period 1
N-1 1
NA 1
Need a Help to Resolve Circular Loop 1
Need Help 1
Need Last 3 years Data 1
Negative values 1
Negativenumbers 1
nested 2
nested Aggregation 1
nested ifs 1
NetworkDaysexcludingholidays 1
new 1
new application 1
New Feature 1
new to 1
New to NPrinting 1
New To Qlik 49
New to Qlik Community 2
New to Qlik Sense 8
new to qlik view 1
new to qliksense 1
New to QlikView 118
new version 1
newbie 1
NewtoQlikView 34
Next 7 Days 1
nhs 3
no null values 1
no selection 1
noconcatenate 1
not in 1
November 2018 1
Nprint 1
NPrinting 2
Nprinting 16 2
NPrinting 17 2
NPrinting 18 1
NPrinting Email 1
NPrinting Excel Report 1
nprinting server 1
nprinting with object filter 1
Null 5
Null value 7
null values 1
Null() 1
NullCount 1
num 2
number format 3
number formatting 1
Numberformat 1
NumberTrimming 1
NVL() 1
object 1
Object Properties 1
objects 2
objeto 1
OCX 1
ODBC 4
Old Forum 1
oldthreads 1
OLEDB 1
OMIT 1
OnDemand 2
OneLogin 1
online 1
only 1
Only Negative values 1
only show certain value 1
open 1
open in server 1
opendocument 1
Optimized Load 1
or 1
ORACLE 3
Oracle Apex 1
OSUser 1
outer 1
Outlook 1
Overlapping 1
p() function 1
parameter 1
parameters 2
parse 1
partial sum 1
pattern 1
Peek 5
peek() 1
percentage 4
Percentages 3
Percentagevalues 1
Percentile 1
performance 4
period 1
Periods 1
personal edition 2
PGN 1
pick 3
pick() 3
Pick(Match()) 2
pie chart 1
Piechart 3
pivot 9
Pivot chart 3
Pivot Dimensions 2
pivot expressions 2
pivot table 17
pivot table expanding column dimension 1
Pivot Table Header Rows 1
Pivot Tables 12
pivottable 4
please help 1
Ports 1
possible dates 1
Possible values 3
PostgreSQL 1
PowerBI 1
practice 1
Preload 1
Previous 4
previous value 1
Previous week Vs current week 1
Previous year 1
price variations 1
print pdf 1
progressive chart 1
proportions 2
Publisher 2
qlik 4
Qlik Academic Program 1
Qlik App 2
Qlik Certification 1
Qlik Chart Functions 3
Qlik Community 32
Qlik Community Team 18
Qlik Connectors 1
Qlik Core 2
Qlik Deployment Framework 2
qlik Developers 6
Qlik Explorer for Developers 1
Qlik Fix 1
qlik hanging 1
Qlik Load Script 2
Qlik Scripting 1
Qlik Sence 2
Qlik Sense 10
Qlik Sense App 2
Qlik Sense Cloud Basic 1
Qlik Sense Desktop 1
Qlik Support 1
Qlik Technology Partner 1
qlik view 5
qlik-sense 1
qlik_sense 1
Qlikivew EDX 1
qliksense 7
Qliksense Scripting 2
Qlikserver installutil.exe 1
Qlikview 75
QlikView 11.2 8
Qlikview 12 7
QlikView 12.2 10
QlikView 12.30.20000 2
qlikview 9.0 developeent 1
qlikview access point 2
qlikview alternate states 1
QlikView App 16
QlikView App Development 32
Qlikview application development 2
QlikView Applications 21
qlikview automation 1
QlikView Buttons Sort 1
QlikView Connector for SAP 1
QlikView connectors to SAP Successfactor & SAP Ariba Cloud Solutions 1
Qlikview Data 1
QlikView Date Range 3
Qlikview Date selector 1
qlikview deployment 2
qlikview design 2
QlikView Desktop 21
QlikView Development 15
Qlikview export current selections 1
qlikview expressions 7
QlikView Features 3
QlikView Governance Dashboard 1
QlikView Hero's 2
Qlikview maps 1
QlikView Publisher 1
QlikView scripting 10
QlikView Server 17
Qlikview subfolders load 1
Qlikview SVG extension 1
qlikview triggers 1
Qlikview Upgrade 1
qlikview Visualization 3
QlikView Where Left function 1
QlikView. 1
Qlikview12 2
Qlilsense 1
QMC 8
qmc access 1
QMC Job Reload setting 1
QMC Not accessible 1
QMSEDX 1
Qonnections 1
Qonnections 2019 8
qsvariable 2
Quadrant in scatter 1
QUALIFY 1
Quarter Year 1
Quarterm 1
quarters 2
quartile calculation 1
quartiles load script 1
query 2
query failing 1
QV server 1
QV services 1
qv12 2
QV12.30 SR1 Desktop QV12.20 1
qvd 13
QVD issue 3
qvdcreateTime 1
QVS 1
qvt 1
qvw files 1
QVX 2
Raking 1
ram 1
range 2
range expression 1
rangeavg 1
rangesum 9
Rank 13
Rank FirstSortedValue 1
rank function 1
rank() 1
Ranking 2
read multiple sheets 1
Reading live reload log through Unix command 1
recovery 1
redirect 1
reduce data 1
Reduction 1
Reference line 4
Reference Lines 1
region 1
Related Products 1
relation between chart and list box 1
reload 5
Reload tasks 1
reload time 1
remove_rows 1
Removenumbers 1
Removingduplicates 1
Rename Field 1
repalce 1
repeat values 2
repeated customer logic 1
replace 3
report 3
Reporting 2
resident 5
resident load 4
Resolution 1
Resources 1
REST 1
REST API 1
Rest Connector 1
restart server 1
Restricted dimension 1
restricted_screen 1
Reverse Y Axis 1
rolling 2
Rolling 12 months 1
ROLLING SUM 2
rounding 1
rowno() 1
Rows 1
Rows to columns 1
Runbook for Qlikview Admin 1
Saas 1
Sales 1
salesforce 1
SAML 1
sample data 1
Sample Data Sets for Exercises 1
save 2
scatter 1
Scatter chart 3
scatter plot 1
SCD 1
Script 27
Script and Expressions 4
script editor 2
script expressions 1
Scripting 12
Scripting and Expressions 1
scrollbar 1
SearchObject 1
seccurity 1
Section Access 7
Section Access in Qlikview is not working 1
Section Access Issue 2
Sections 1
Security 2
segment colors 1
segments 1
select 1
selected values 2
Selection issue 1
selections 1
SelectValues() 1
SemanticError.Script.NextT. 1
series values 1
Server 4
services 1
session calls 1
session duration 1
Set 4
Set Analisys 8
Set Analyse 1
Set Analysis 52
Set Analysis syntax 1
Set Expression 2
set expressions 8
set modifier 1
set statement 1
set_analysis 2
set_modifiers 1
setAnalysis 1
setexpression 1
SFDC 1
Sharepoint 1
sharepoint to qlikview connection: 1
sheet 2
sheet properties 1
sheets 2
Shell 1
Show and Hide columns conditionally 1
show conditions 2
Show Hide column based on a button click. 1
SHOW MATCH AND NOT MATCHED VALUES INTERVALMATCH 1
simba 1
slider 5
Smallest 1
Smallest10 1
Snapshot 1
sort 4
sort bar chart 1
Sort by expression 2
sort for expressions 1
sorting 4
sorting values 1
speed 1
Split 1
splunk 1
SQL 7
SQL Data load 1
sql import 1
SQL Server 1
SSL 1
SSO 1
Stacked 2
stacked bar chart 2
stacked chart 3
stacked hart 1
StartDate 1
statement 1
static 1
Static chart 1
static data 1
statistics 1
Stock 1
store CSV 1
straight chart 2
Straight Chart Expressions 1
straight table 19
Straight table and pivot table 1
Straight table expression 7
Straight Table Hide Show 1
string function 1
String to date 1
Sub 1
subfield 3
Subfield Function 2
Subroutine 1
substring 1
subtotal 1
sum 16
Sum divide invalid dimension 1
sum expression 1
SUM IFS 3
sum of previous record 1
Sum with If 1
sum-if 1
sumif 2
Summary Set Expression in Text Object 1
SumofValue 1
Sumproduct 1
sunny_talwar 18
Supported platform 1
suppress 1
suppress null 1
SuppressZeroValues 1
Surveys 1
switch 1
swuel 5
Symbols 1
Sync 1
syntax 2
Synthetic dimension 1
synthetic key 1
tab 1
table 12
Table chart 3
Table Transformation 1
Table with duplicate rows 1
Tableau 1
tables 4
Target 1
Target Table 1
Task Chain 1
tasks 1
Test server 1
text 2
text format 2
text object 1
text on axis 1
TextBox 1
textformat 1
time 4
time difference 1
time duration 1
TimeDifferencebetween2timestamps 1
timeline 1
Timestamp 4
title. 1
Today() 1
Toggle Button ot switch between two dashboards items 1
Tooltips 1
top N 3
Total 5
total amount 1
Total Distinct Product Used by each Customer 1
Total straight table click 1
total value 1
transfer 1
transform 1
Transpose 2
tree 1
Trend 1
trend line 5
tresesco 1
trigger 2
Triggers 4
trim 1
trimming the field values 1
two dimension 1
uacg0009 1
Unable to open file 1
Unable to read file 1
unique identifier 2
unqualify 1
Update 3
Update field value. 2
Updates 1
Upgrade 1
Upgrade QV12 issue 1
upload 1
URL Hyperlink 2
usage 1
User preferences 1
value 2
value on data points 1
Valuelist 1
values on data points 1
values on the data points 1
VaR 1
varaible 1
variable 6
Variable value 2
Variable values 3
Variable values to List Box Values 1
Variables 14
Variablesinsearchobject 1
VBScript 5
Version Control 1
Versions 1
vertical line 1
views 1
visualizar 1
visualization 4
vlookup 1
VPN 1
vs 1
Waterfall Chart Qlikview 1
Web Access 1
Web Connectors 1
Web engine 1
Webview mode 1
week 1
weekday 1
whatsaap 1
Where 4
Where clause 1
where exists 1
Where Not Exists 1
wildmatch 4
windows 10 1
without partial sum 1
working 1
worksheets 1
XML 2
year 2
Year on Year 1
Year-Over-Year 1
YearFilter 1
YOY 3
ytd 2
YYYYMM 1
zero 1
zeros 1
Último registro 1

New to QlikView

Topics with Label: excel

Inputting an excel table with multiple headers

Macro to merge cells doesn't work

How to export two tables at the same time to Excel...

Number Format for a calculated field in script

Loading multiple excel files and sheets not workin...