Resources

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Using Dual and Concatenate in a Pivot Chart Expres...

by on Latest post on by

7 Replies 271 Views

7 Replies

271 Views

Labels

$(field) 2
$expansion 1
$field 1
$Info 1
% 1
% Year over year( YoY) 1
' - ' 1
'' 1
'break line' 'chr' 'replace' 1
'Qlik Sense' 1
-2 1
. 1
0 values 1
0 valure 1
1) 1
12.40 2
2 tables 1
445 calendar 1
5-4-4 financial year 1
@datamodelling 1
@Gysbert_Wassenaar 1
@Henric_Cronström 1
@hierarchy 1
@Jagan 2
@MarcoWedel 1
@PDF_in_Qlikview 1
@qlikview 2
@rwunderlich 1
@rwunderlich @marcus_sommer @Oleg_Troyansky 1
@sunny_talwar 13
@sunnytalwar 1
@Taoufiq_Zarra 1
abbreviation 1
ABC analysis 1
abort 1
above 5
above() 1
Above() function 6
Access 1
Access Denied While exporting chart to network shared folder 1
Access Point 9
accesspoint 4
accumulates 1
Accumulation 3
action 1
Actions 10
Activate Sheet 1
Active Directory 2
ActiveDocument 1
acumulación 1
acumulado 1
acumulados 1
AD 1
add 2
Add new rows to an existing column 1
adding text 1
Addmonths 2
adhoc report issue 3
Admin 1
Advance scripting 1
Advanced Aggr 2
Advanced qlik 1
Advanced Qlikview 2
Advanced Search 1
advanced set analysis 3
aggr 30
Aggr and Average - Syntax 1
aggr function 3
AGGR in set analysis 2
Aggr or Set Analysis 7
Aggr Sum 3
AGGR() 28
Aggr. Function 2
aggregate 4
aggregated data 2
aggregating data 1
aggregating grouped dimensions 1
aggregation 6
Ajax 2
Ajax Accesspoint 1
AJAX and IE 1
Alarm 1
alert 2
alert qlikview 1
Alert wizard 2
alerts 1
aligment 1
alignment 1
allocation 1
Alphanumeric 1
Alt 2
Alternate rows 1
alternate state 1
Alternate States 11
Alternative state 1
Alteryx 1
always one selected value 2
amortization 1
amount 2
Analysis 1
and 1
AND logic 1
animate 1
animated graph 1
animation 2
anomalies values 1
anonymisation 1
API 5
APIs 3
app 1
App contents 1
App Design 3
App Development 33
application 2
Application access issue 1
application development 2
applymap 2
Applymap() 2
Approximate Match 1
April 2019 1
April 2019 IR vs SR 1
argb 1
array 2
Assign one Row to multiple Filter Options 2
attributes 1
authorization 1
AUTIMATED_TESTING 1
AutoGenerate number 1
Automation 2
autonumber 3
autonumber() 4
average 4
average calculations 1
average formula 1
Average Trendline 1
avg 3
avg() 3
avoid 1
AWS 1
axis 4
Ayuda 3
Azure Cloud 2
background 1
background color 5
Background color for missing value row 1
Background color In pivot table 1
background colour 3
background expression 2
backgroundColor 1
backgroundcolorexpressions 1
bag 1
Balance sheet 1
Banding 1
bar 1
bar chart 14
bar chart expressions 3
Bar Chart with Month and Year 1
Bar chart with values 1
Bar charts 5
barchart 7
Based on min value of seq number for Key 1
based on Sample work data Need output as below 1
based on selection previous years data 1
bat 2
batch 1
before 1
Bell chart Normdist 1
best practice 1
between 2
between two dates 2
Big Data 1
Big File Size 1
big picture 1
bigdata 1
binary 2
binary excel file 1
binary format 1
Binary Load 1
binary number 1
bit 1
Bitand 1
blank 2
Blank Chart 1
block chart 1
bnf 1
bookmark 5
Bookmark Trigger 1
bookmark vbscript 1
Bookmarks 7
borders 4
Box Plot 1
boxplot 1
Browse_for_File 1
bubble 1
bubble size 1
Bucket 2
Bucketing 1
bug 10
bug wildcard binary load 1
Bugs & Errors 1
Bundle 1
businesshours 1
button 3
button action 1
Button Actions 4
Button to select Field 4
ButtonActions 1
buttons 4
Cache 1
calander 1
Calculate dimension 1
Calculate percentage 1
Calculate Sequence 1
Calculated Color 1
calculated column 2
Calculated date 1
Calculated Date Dimension 1
Calculated dimension 12
Calculated Dimension Colors 1
calculated dimension issue on pivot table 1
calculated dimensions 7
calculated field 7
calculated periods 1
calculation 3
Calculation Condition 4
calculations 4
calculo 1
calculte amount of time in minutes 1
calendar 11
Calendar Control 1
calendar script 2
campos 1
can someone give some hint please 1
Canonical Date 1
caption 2
case 1
Case Study 1
category 1
ceiling 1
cell formula 1
Chaining 1
change color of the legend in bar or line chart 1
change selection 1
Character Set 2
chart 25
chart aggr dimension pop-ip 1
chart expression 2
chart expressions 1
chart function 2
Chart in QlikView 4
Chart Object 13
chart selections 1
charts 8
Charts Select 2
check 1
Checkbox 1
chi squared 1
chr(10) 1
chr(13) 1
chr(39) 1
chrome 1
Circular reference error 1
cisco webex connector 1
class 2
CLAUSE 1
clear all 1
ClearAllTrigger 1
ClearFields 1
click twice 1
Closing_Employee 1
Cloudera 1
cluster 3
CODES 1
coding 2
Collapsible Dimension 1
Color 9
Color by dimension value in qlikview 2
Color condition error 1
color expression 1
colorcode 1
Colorexpressions 1
ColorMix 2
Colors 3
colour 1
column 4
column dimension 2
column headings 1
Column Set analysis 1
column title 1
column total 1
columns 3
columns dynamically from excel sheets 1
columns Filter 1
Combination of Budget and Actuals 1
Combine fields 2
Combo Chart 10
combo charts 2
comma separated 1
comments 2
Community Help 2
community launch 1
COMPARATIVE 1
Comparative two numeric columns 1
compare 2
Compare Dates in between in another column 1
Compare fields between two tables without having a common column 1
compare sales from two tables 1
comparing periods 1
comparison 4
comparison between months 1
complex measure 1
complex requirement 1
Composite FROM 1
composite key 1
Concat 6
Concat on two generic fields 1
Concat() 2
concatenate 2
Concatenate 2 Fact tables 1
concatenate expressions 1
Concatenate fields 1
Concatenate x Lef Join 1
conctenated fields 1
condition 4
conditional 2
conditional collor 1
Conditional Column 1
Conditional Date Format 1
conditional display 2
conditional expression 1
Conditional Expressions 3
Conditional formatting 3
Conditional images 1
conditional sum 1
ConditionalExpressions 2
Conditions 2
condtional 1
conection 1
conexão 1
Configuration 1
Confused what could be wrong 1
conn 1
connect 1
connected 1
connection 3
Connection to Oracle 1
Connector 1
consecutive quarters calculation 1
consecutive targets 1
container 5
Container Pivot Table export to Excel 1
conteo semanal 1
continuous variable 1
contro de acceso 1
convert if to set analysis 1
convert straight table 1
copy text 1
Copy Value 1
Copying data 2
Correlation 1
Corrupt 1
Cost 1
Count 32
count aggr 1
Count Aggr If 1
count distinct 1
count distinct id 1
Count if 1
Count of distinct with set analysis 2
count of division calculation 1
count of sum 1
COUNT Parameters 2
Count the number of leave days from start and End date and Exclude the weekend day. 1
COUNT UNIQUE OCCURENCE 4
Countif 1
counting 1
cpu 1
create 3
create a customised field 2
Create Expression from different tables 1
create new table less than target sequence number 1
Cross Tab 2
Cross Table 2
crosstable 1
Crosstable multiple rows 1
CSV 2
Cummulative 1
cumulation 1
Cumulative calculation using range sum function 1
cumulative sum 2
cumulative sum in chart 1
Cumulative summation by date 1
Cumulative summation by dimensions 1
Currencies 1
Current Selection 5
Current Year 1
CurrentSelections 2
curve 1
custom 1
Custom Color 1
custom totals 1
cycle group 1
cyclic group 1
Cyclic Group Dimension 1
Dashboard 6
data 4
data across dimensions 1
data aggregation 1
Data Analytics 1
data checks 1
data converting 1
data discovery 1
Data Governance 1
Data inconsistancey in Qlik Script and SqL script 1
data loading 1
Data Manipulation 1
Data matching 1
Data Model 8
Data model Issue 1
Data model viewer 1
Data Modelling 11
data point 1
DATA REDUCTION 1
data refresh 1
Data Science 1
data table 1
data type 2
data validation 1
data visualization 1
data_loading 2
database 1
database connnection 1
database information table 1
Datamodel 2
datamodel logic 1
datamodeling 2
datarestriction 1
Date 37
Date & Time 4
date bridge 1
date calculation 1
date comparison 2
date conversion 1
Date converting 6
Date Expression 1
date field 2
date field value 1
Date filter 5
date format 3
Date format wrong. 2
date formatting 1
date function 1
Date Functions 2
date interval 1
Date Order 2
date picker 1
Date Range 5
Date range picker extension 1
Date ranges 2
Date selection 1
Date Time interval 1
date time timestamp 1
DATE VALUE 8
Date Variable 2
date variables 1
Date_Missing 1
DateFilter 1
dates 13
dates comparison 3
Dates Help 3
datestamp 1
Datetime Calculation 1
Datum 1
daymonth 1
DayNumberInQuarter leap year 1
DCom 1
deafults 1
decimals 4
default 1
default selection 1
Default value selection from List box 1
delete 2
Delimiters 1
Demension 1
demo 1
Deployment 1
Design PDF as per client requirement 1
Designer 3
designing 1
desktop client 1
Developer 7
Developer Toolkit 1
Development 22
diagram 1
difference 1
difference between tables 1
Different font and style in qlikview text object 1
different periods values 1
DimensaoDistinta 1
dimensie 1
Dimensiom 1
dimension 20
Dimension as expression 3
Dimension axes 2
dimension counting 1
dimension in pivot 1
Dimension labels 2
dimension limit 3
dimension limits 1
dimension set analysis 1
dimension values 1
DimensionLimit 1
Dimensions 20
dimesao 1
Dimesnion % Calculation 1
Direct Discovery 1
Direct Discovery Issues 1
Directory Service 1
Directory Service Connectors 1
DirectQuery 1
disable repository 1
Disaster Recovery machine 1
Display label 1
Display New customers Year on Year 1
Display values in straight table 1
Distinct 7
distinct count 1
Distinct values 1
distribute 1
division 2
Division by Variable 1
DLP 1
Document 2
Document Analyser 1
Document Chain 4
document chaining 2
Document chaining In Qlikview 4
document open 1
documentname 1
doesn't null value 1
Dollar expansion 1
Dollar Sign 1
Dollar sign expansion with variable with & operator 1
double counting 1
Double Dimension 1
download-old-version 1
DragDrop 1
Drill-Down 2
drilldowndimension 1
drop down menu 1
drop down select 1
Drop fields 1
Dropdown 1
DSC service 1
dual 1
dual data type 1
Dual Set Expressions 1
duplicate 3
duplicate fields 1
Duplicate Rows 1
duplicates 1
duration 1
dynamic 3
Dynamic Assignment 1
Dynamic Charts 1
dynamic dimension 1
dynamic field name 1
Dynamic FilePath 1
Dynamic filter 1
Dynamic selections 3
Dynamic triggers 1
dynamic update 1
Dynamic value 1
dynamic variable 1
dynamically from excel sheets 1
DynamicColumns 1
DynamicFilter 2
dynamicUrl 1
E() 1
edit 1
edit expression 1
Editing 1
editing tabs 1
education 1
efficiency 1
email 4
email alert 2
email URL 1
Employee_No 1
Enable Conditional 1
End user statistics 1
enddate 2
enterprise 1
Entity Report 1
equals 2
Error 5
Error in qmc app while running in qmc 1
Error Message 1
Error Messages 1
Errors in Qlikview dashboard while running 1
ETL 1
Europe KML file 1
every data row 1
excel 7
Excel data 5
Excel data sets to Qlik 1
Excel Export Logs 1
Excel Exports 10
Excel file download 1
Excel load to Qlikview 1
Excel Pivot table 1
excel sheets 1
exchange Rate 1
exclude 2
exclude data 1
excluded selections 1
Excluded Values 4
Excluding Selections 1
exclusion 1
Execute Command 1
execution failed 1
Exists 1
exit script 1
expansion 1
ExpDate 1
Explicit Labels issue with excel 1
Export 4
export delimited file 1
export excel file 1
Export ExportEx Excel Qlikview Server 1
export ppt 1
export to excel 1
Exporting Current Selections to excel 1
expresion 1
expresison 1
Expression 83
Expression builder 3
Expression Challenge 3
Expression Error 4
expression syntax 1
Expression Total 1
Expression value selection in to dimension 1
Expressions 28
expressions straight table 1
Extension 1
Extension Objects 4
External 1
extra dimension 1
Extract 6
extraction 1
Extractor 1
Facebook 1
fact table 2
fail to load 1
failed 1
failed to load 3
failover 1
Fecha 1
Few sheet properties missing in access point 1
field 4
field as variable 1
Field Event Trigger 2
Field Load 1
Field name 2
field not found 1
field not found error 1
field seletion 1
Field value 1
FieldNumber 1
fields 4
fieldselection 1
file 2
File Size 1
file size large 1
filepicker 1
files 1
Filetime 1
Filter 14
FILTER BY DATE 2
Filter condition +Condition Filter - Need help here 1
Filter condition in qlikview 2
Filter Null Values 1
Filter only on some data 1
filter panel 1
filter selections 1
Filter Visualization 1
filtering 2
filters 3
Filtros 1
FindOneOf(RefIDWL 1
first sorted value 1
First value 1
FirstSortedValue 4
Firstworkdate 1
Fiscal Calendar 1
Five9 1
fixed 1
FIXED Position 1
fixed value 1
flags 1
flat file 1
flat table 1
floor 1
foirmat 1
folder 1
Folders 1
fonts 1
for loop 2
for next 2
Forecast 3
Forecasting 1
format 2
format axis 1
format num 1
Formating 3
formatting 1
formula 10
formula last year 1
formula sum 1
Formular sum 1
Formules 1
fractile 2
freeze pane 1
from 1
FROM statement 1
full accumulation 1
Función 1
function 4
functions 3
Gantt chart 2
Gaps for purchased date of repeated customer 1
gauge chart 2
Generate an APP 1
Generate dates 1
Generate Logfile 1
Generation 1
generic load 1
GetCurrentSelections() 1
GetFieldSelections 4
GetPossibleValues 1
google map 2
Google Maps 1
Googleapis 2
GoogleMap 1
Googlemaps 4
governance dashboard 1
gradient 1
grafico 1
GraficoCombinado 1
grain mismatch 1
grand total 1
Graph 10
graphics 1
Graphs 2
greater than 2
greater than equal to 2
Greentree 3
Grid chart 2
Grid Chart Labels using Dual Aggr() 1
gridchart 1
group 4
group by 7
Group by in Load 3
GROUP BY ISSUE 1
group dimensions 1
group rank 1
Grouped Bar Chart 2
Grouped data 1
grouping 3
Groups 1
Guage in straight Pivot tables. 1
Gysbert_Wassenaar 1
hash 1
having count 1
header 3
Header column Pivot 2
help 2
Help ! 2
Help me Set Expressions 1
Help required 2
Help required on Front End 1
Henric_Cronström 1
hide 3
Hide and show 1
hide excluded 1
hide rows 1
hide specific values 1
Hide Values on x-axis 1
hierarchy 6
Hierarchy Dimension 1
Highlight based two different set of tables and on field value 1
highlights 1
hint would be fine 1
Histogram 1
historic 1
Hive 1
Hive Connection 1
holiday 1
Holidays 1
Hour 1
Hourglass 1
hours 1
Hover. Help Text. 1
how to calculate amount based on discount % 1
how to combine and show 2 columns from different table as 1 list box 1
How to Transpose Need some help 1
HTML 2
HTTP 1
Hyperlink 4
ID 1
identical rank values 1
Identifiers 1
IE 1
IE Plugin 1
if 5
IF & OR 2
IF AND STATEMENT 3
if clause 1
if condition with multiple values in Qlik sense 1
If else 1
If Else Expression 1
if expression 2
if function 1
If stament 2
if statement 9
If statement exclusion 1
if statements 1
If statment 1
if-statement 1
IF...THEN 1
Ifcondition 1
iferror 1
ignore 1
Ignore dimension 1
ignore filter 1
ignoring selections 1
image 2
Images 2
Images in Expression level 2
Imoprt Web Files. 1
Importing data script 1
in script editor 1
include filters 1
Inconsistency Error 1
Inconsistent results 1
incremental 1
Incremental Load 2
Incremental Load on Date condition 1
IncrementalLoad 1
Index 1
infoload 1
inline 1
Inline Load 2
inner join 1
input 3
input box 6
Input data 1
inputfield 1
inputfields 2
inremental qlik 1
Insert 2
insert from qlik 1
insert with load 1
Instrument for Data flow 1
Integer 2
Integration 1
Inter record functions 1
interest rates 1
interface 1
Interpolation 1
interpreting 1
intersection 2
interval 4
Interval Dates 1
Interval Match 1
Interval Match Calender 1
IntervalMatch 4
IntervalMatch on multiple fields with multiple condition in a table 1
Intervals 3
intraday 1
InYearToDate 1
IRR 1
Irregular CSV file 1
Is the equation of Y Correct Thanks! 1
issue 1
iteration 2
jade 1
jagan 1
Java 2
javascript 2
jira 1
JMeter 1
johnw 1
join 8
Join Logic 1
Join or Mapping Performance 2
Join Query 4
Join Scripting 3
Join Table 1
Joining 3
joins 1
jscript 1
JSON 2
JSON Load 1
Json web 1
julian sql filter 1
keep dimension constant 1
keep numbers 1
key fields 1
KPI 1
KPI Chart 1
label 1
labels 2
labels and font 1
landing 1
larger than 1
largest 1
Last month 2
Last value 1
last year 1
Lastvalue() 1
lastworkdate 1
launch 1
Layout 3
Layout & Visualizations 3
LDAP 1
Leading zero 1
Leap Year 2
Leave calendar to count the actual leave. 1
Lebanese pound symbol 1
left join 1
Left Join between multiple QVD's 1
LEN 1
less than 2
let 1
LET using where clause 1
Licence 1
licence management 1
License 2
License allocation 1
limit 2
limit selections 1
limite 1
limited dimension 1
limiting Dimension values 2
line break in print preview 1
line chart 12
Line Chart Dimension 1
Line Chart Missing Data 2
Line Chart requirement 2
Line chart using reference line and below of the chart data should be display. 1
line graph 3
linear regression 1
LineChart 1
LineChartExpression 3
Link 1
linking 1
linking fields 1
list 1
list box 5
List Box expression 2
List Box Range Values 1
Lista campos orden 1
Listbox 17
listbox tab 1
lists 1
live 2
load 12
Load Data 10
Load Data distinct 2
load excel files 1
load excel files no data 1
Load JSON 1
load numbers 1
Load Script 22
Load Script Error 1
load table 1
Load tables based on condition 1
load with fieldnames 1
Load YTD & Sum of all prior YTD Values - to display P&L & Balance Sheet for all company codes 1
loaders 1
loading 1
loading data 4
Loading xlsb files to Qlikview 2
Locale 1
Localized date format 1
lock 1
Locked selections 2
Log configuration 1
Log Files 4
log issues 1
logging 1
Logging files 1
logic 4
Logic Calculation 1
Logic in script 2
Logics 4
logs 1
lookup 5
lookupmax 1
Loop 6
Loop and Reduce 1
loop data model 1
loop in script 1
loop with multiple condition 1
Looping variable script 1
loops 3
Loops and Iterations 3
Lost connection to server 1
Macro 28
Macro export 6
macro showsheet setproperities 1
macro table box straight table 1
macros 12
mailto 1
Maker 1
makro 1
ManagementConsole 2
manual 1
Manual field 1
map 2
Mapping 3
mapping load 1
mapping table 1
Maps 5
master calendar 9
Master Calendar with Sequence Dates 1
Master calendars 1
Master calender 1
Match 5
Match Function not working in multiple date selections 1
Match multiple values 1
match() 1
maths 1
max 4
max (date) 1
max date 1
max Date in Set Analysis 1
Max Date Qlik Sence Help 1
Max Date Value 2
MAX dates vReportDate greentree set analysis 1
Max Function 3
Max value next column 1
Max() 1
max(date) per month 1
MaxDate 1
maximum measures 1
mdb 1
Mean Moving Range 1
measure 2
Measure Expression 1
measures 1
Measures expressions 1
Median 1
Median Calculation 1
Mekko chart 1
memory stats 1
Memory usage 1
menu 1
merge 1
Merge Rows 1
meta file 1
Metadata 1
Metrics 1
Metro Map 1
Migration 1
Migration of the Qlik apps 1
Migration of the Qlik apps. 1
Min 5
Min function 1
Min() 3
Minichart 1
minus 1
minute 1
minutes 1
Missing 3
Missing Data 1
missing dates 1
Missing Fields 1
missing records 3
mixmatch 1
Mobile 1
mode 1
modeling 1
Modelling question 1
modifier 1
module editor 1
money 1
Monitor 1
month 3
Month not rolling up for single total 1
Month Selection 1
month sum 1
Monthend balance 1
monthly 2
Monthly trend 2
monthlydatacomparison 1
MonthName 1
MonthNumber 1
monthrangefilter 1
months 1
Moving Average 1
moving labels 1
mp4 1
msi 1
mst 1
MTD 2
Multi Box 3
multi dimension 1
Multi dimension chart 4
multiple 3
Multiple Alternate state 1
Multiple between in set analysis 1
Multiple Criteria 1
multiple date 1
multiple dimensions 4
Multiple fields 3
multiple filters 1
Multiple lookup 1
multiple results 1
multiple selections 1
multiple tables 1
multiple value filter 1
multiple values 1
multiple values for expressions 1
multipleValues 1
mysql 3
MySQL database 1
n-levels 1
Navigation 1
Nearest value for 2 columns 1
Need some help to present data in chart 1
Need to calculate the month wise leave day and working days and exclude the weekend day. 1
Negative and Positive Values in Pie chart 1
Negative values 1
negative zero 1
nested 1
nested Aggregation 3
Network 1
Networkdays 2
Networkdays() 1
New if Condition 1
new key 1
New Qlik Community Design 2
New Qlik Sense 2
NEW QLIKVIEW 2
new table 1
New To Qlik 15
New to Qlik Community 1
New to Qlik Sense 3
New to QlikView 17
NewtoQlikView 6
newtowlikview 1
No Labels issue with excel 1
no measure 1
no of customers 1
no value 1
NoOfColumns 1
NoOfRows 1
Not 1
not displaying 1
not exists 1
Not getting the MAX Month Data of latest year 1
not in 2
Not WildMatch 1
Not work Trigger OnPostReload 1
NPrinting 9
NPrinting 17 2
Nprinting on demand 2
NPrinting September 2018 1
nprinting task 2
nprinting17 2
Null 3
null dimensions 1
Null Display 1
Null value 4
Null values 4
null values in pivot table 1
Null() 1
NullCount 1
NullInterpret 1
Nullvalues 1
num format 1
Num function 2
number 1
number format 1
number formating 1
number of days 1
numbers 3
numbers in string 1
OBDC 1
object 2
Object Properties 1
objects 1
occurences 1
ODAG 4
ODBC 6
OMIT 1
on demand app generation 2
on post reload 1
onChangeTrigger 1
OnDemand 2
One bar chart 1
one dimension 1
online 1
only 4
Only function 1
OnOpenTrigger 1
open documents 1
open in server 1
open pdf link 1
open qlikview document 1
Open URL 1
OpenApp 1
Opening 1
openurl 3
OPTIMIZATION 2
Optimized Load 2
or 2
ORA-12154 1
ORACLE 2
Oracle Database connection 1
order 1
order by 1
OSUser 1
osuser() in P function 1
OtherSymbol 2
Outlook 1
Overview 1
P function 3
p() 1
p() function 1
Pair values script 1
Palette 1
parameter 3
parameters 1
Pareto 3
Pareto analysis 1
Pareto count 1
part 1
partial sum 3
password 1
path 1
PDF 2
PDF reports 1
Peek 6
PEEK as expression 1
peek() 4
percent 2
Percent Symbol 1
percentage 4
percentage during count function 1
Percentages 1
percentagevalue 1
Percentile 2
PERCENTILE_DISC 1
Performance 6
Performance Dashboard 1
performance issues 2
performance optimization 1
PerformanceIssues 3
permisos 1
Personal Edition 2
pick 3
pick() 1
Pick(Match()) 2
pie chart 6
Pie chart and color 2
pie chart and percentage 1
Piechart 1
pivot 11
Pivot chart 6
Pivot Dimensions 6
pivot expression 1
pivot expressions 1
Pivot Filter 3
Pivot Headings 3
Pivot Measure 1
pivot table 19
Pivot table behavior 1
Pivot Table Expression 4
Pivot Table Total 2
Pivot table with aggregation count in the corresponding field 1
Pivot Tables 18
Pivot Tables Total 1
pivottable 1
plot 1
Plugin 1
point-in-time 1
Polish Character 1
pop up 1
Populate Column Data 2
Populate null values 1
possible dates 1
Possible selections 3
Possible values 2
PostgreSQL 2
PowerBI 1
Preload 1
presentation 1
preview 1
Previous 4
Previous Date 1
previous value 2
Previous year 2
Previous Year Month 1
Previous() 1
previousperiod 1
price 1
print 1
Print to PDF 1
Printing 1
profile users 1
purgechar() 2
PYTD vs YTD 1
QDF 1
QIX 1
QIX Performance 1
QlickView Apps on cloud 1
qlik 9
qlik analytics 1
Qlik Analytics extensions 1
Qlik App 15
Qlik Chart Functions 3
Qlik charts 1
Qlik Community 22
Qlik Community Team 5
Qlik Connector 1
Qlik Connectors 1
qlik desktop 1
qlik Developers 3
Qlik Development 12
Qlik Engine JSON API 1
Qlik Explorer for Developers 2
qlik expression 3
Qlik Fix 1
Qlik Help 2
Qlik Load Script 2
Qlik Market 1
Qlik Mashup 1
qlik newbie 1
qlik regardless any selection 1
Qlik Sence 2
Qlik Sense 13
Qlik Sense App 3
Qlik Sense App Development 1
Qlik Sense Data Architect 1
Qlik Sense Desktop 1
qlik sense development 1
Qlik Sense Functions 1
qlik sense script 1
qlik server 1
Qlik set analysis 1
qlik view 9
Qlik View Development 6
Qlik View QMC 2
qlik view tree view list box not consistent in all sheets 1
QlikBrasil 1
Qlikmap 1
qliknewbie 1
qliksense 7
Qliksense app development 2
qliksense chart 1
Qliksense Dev and Prod Migration 1
Qliksense development 3
qliksense filter 1
Qliksense Scripting 2
Qliksense Task Reload 1
qliksensecloud 1
QlikTech 2
QlikView 152
QlikView 11.2 9
Qlikview 12 9
QlikView 12.2 12
Qlikview 12.20 4
QlikView 12.30.20000 6
qlikview 9 1
qlikview access point 3
Qlikview advanced 1
Qlikview Analyst 1
QlikView App 33
QlikView App Development 143
Qlikview application development 4
QlikView Applications 21
qlikview april 2019 1
Qlikview April 2020 1
QlikView Assessment 1
Qlikview Backend Script Help - 1
QlikView bug 2
QLIKVIEW Calendar 1
Qlikview challenges 1
QLIKVIEW Chart 46
QLIKVIEW chart expressions 23
qlikview chart with 2 dimensions Screen shot pasted 1
Qlikview Data 2
QlikView Date Range 2
Qlikview Date selector 1
qlikview deployment 3
qlikview design 6
QlikView Desktop 13
QlikView Development 35
qlikview development environments vm aws 1
QLIKVIEW Dimensions 7
qlikview expressions 7
QlikView Extensions 2
QlikView Features 3
qlikview function 1
QLIKVIEW help 3
qlikview line chart 1
Qlikview load 1
Qlikview Macro 1
Qlikview maps 1
qlikview metadata 1
Qlikview Migration Issues 2
QlikView news 1
QlikView November 18 1
Qlikview November 2017 SR6 1
Qlikview November 2017 SR7 1
qlikview ocx 1
Qlikview On Demand Application 1
QlikView OpenURL 2
qlikview output 1
Qlikview Pivot table 1
Qlikview Pivot table not displaying the correct count and sum in bucket. 1
Qlikview print settings 1
QlikView Publisher 1
Qlikview Report -PDf generation 2
Qlikview Report Editor 2
Qlikview reports 2
Qlikview Scalability 1
QLIKVIEW Script 53
QLIKVIEW script - Need help in transforming data 5
QLIKVIEW Script help 21
QLIKVIEW Script help - 1
QLIKVIEW Script help - Need field repeated with last occurrence until there is change in value. 1
QlikView scripting 17
Qlikview Section Access 1
QlikView Section Access Tab show hide 1
qlikview security 1
QlikView Server 3
QlikView Server Upgrade 1
qlikview service 1
Qlikview Set Analysis 2
qlikview shared file 1
QlikView SharePoint Connector 1
Qlikview Straight table 1
QlikView support 1
Qlikview to SQL server 1
qlikview triggers 1
Qlikview Upgrade 3
qlikview Visualization 1
QlikView Webview Mode 1
qlikview-7-download 1
Qlikview12 5
Qlikviewupgrade 1
qlilkview 1
qliview 4
QMC 13
QMC - Auto Qvf file deployment 1
QMC running 1
QMC supporting tasks 1
qmem 1
QMS 1
QMSAPI 1
QMSEDX 1
QTD formula with set Analysis 1
QTR 1
Quadrant in scatter 1
QUALIFY 1
quarter 1
Quarter display 2
Quarter Year 4
query 1
quotation 2
qv 1
QV April 2019 1
QV calendar 1
QV server_model name not shown 1
QV11 AND QV12 1
QVD 13
qvd box 1
QVD data source 1
QVD ETL 2
qvd files 2
QVD Generator 2
QVD issue 3
QVD to SQL server. 1
QVDs 2
QVP 1
QvPath 1
QVPR 1
QvRoot 1
QVS 1
QVS memory leak 1
qvw 6
qvw files 1
QvWorkPath 1
QvWorkroot 1
QVWS 2
Random 2
random list values 1
range 1
range expression 1
RANGE VALUES 2
rangeavg 2
rangemin 1
rangesum 9
RangeSum() 1
Rangesum() Function 2
Rank 15
rank function 1
Rank Sort by Expression 2
Ranking 4
Ranks 1
rate 1
ratio 1
real-time 1
recargas 1
recarregar 1
recno() 1
Reconciliation 1
Recover 1
recovery 1
Recreate Excel Pivot Table In Qlikview 1
Redshift 1
reduce data 2
Reference line 1
Reference Lines 1
refresh rate 1
regex 1
relations 1
relative 1
relative % 1
reload 10
reload data 1
Reload Error 1
Reload failure 1
Reload Queue 1
reload qvd 1
reload qvw 1
Reloads task fail 1
reloadtime 1
rename 1
Rename Field 1
rendering 1
Repeat Data 1
Repetitive Sorting 1
replace 2
repopenedrequests 1
report 6
report editor 1
Reporting 2
reports 2
repository 1
repyament schedule 1
Research 1
resident load 4
resize 1
Resolution 1
REST 1
REST API 4
Rest api pagination 1
Rest Connector 2
RGB 1
Rob Wunderlich 1
Roll Up Sum 1
rolling 1
Rolling 12 months for each month in Backed script 1
Rolling 4 week average 1
Rolling Average 1
rolling monthly 1
rolling N months 1
ROLLING SUM 2
RollingMonth 1
Rotate 1
round 1
round function 2
round up 1
rounding 2
Rounding value Issue 1
Row wise 1
rowno 1
rowno() 4
Rows 1
rtf 2
Rwunderlich 1
Same records 1
SAP 1
SAP BW Report Data Fetch 1
SAP Connectors 1
SAP Report 1
Save Error 1
scale 2
Scatter chart 4
scatter plot 1
SCD 1
SCENARIO 2
schedule 1
schema 1
scipting 2
Script 58
Script and Expressions 9
script editor 1
script expressions 1
Script level sorting 3
Script Logic 19
Script Parameters 1
Scripting 24
Scripting - Mapping 1
Scripting and Expressions 2
scripts 1
Scroll Bar 1
scrollbar 2
scrolling 1
Search 4
search and replace 1
search object 1
Search Qlikview Object by Search Object !! 1
search string 1
sección de acceso 1
Section Access 25
section access duplication document application 1
Section Access Hierarchy 2
Section Access in Qlikview is not working 2
Section Access Issue 4
section access table profiles 1
Sectionaccess 1
Security 7
security rule 1
segment 1
seguridad 1
seleccionar 1
Selecciones 1
select 2
Select Bar 1
select excluded 1
select in field 3
selected value 1
selected values 1
selection 5
Selection API 1
selection box 3
selection criteria 1
Selection issue 2
selections 5
selectvalues 1
Self referencing column 1
self-referencing table 1
selfjoin 1
semana 1
Semaphore 1
Send to Excel 2
sense server 1
Separate out the layout(UI) part and the data from a .qvw file 1
Sequence 1
Sequence using Above() 1
Server 3
server bookmarks 1
Server CPU 1
Server Migration 1
Server RAM 1
ServerObjectHandlerBatch 1
session cals 1
set an 1
Set Analisys 34
Set Analyse 4
Set Analysis 126
set analysis average 1
Set Analysis Expression 18
Set Analysis filter is not working as Expected 2
set analysis for rolling 6 months 1
set Analysis Measures 1
Set Analysis Modifiers 2
Set Analysis syntax 3
Set Analysis Syntax Error 2
set analysis variable 1
Set anaysis 1
Set Date 1
Set Expression 7
set expressions 4
set operands 1
Set Variable 1
set-analysis 3
set_analysis 2
set_modifiers 1
SetAnalyisis 1
setAnalysis 5
setexpression 1
sets 1
Sharepoint 4
sharepoint to qlikview connection: 1
Sharepoint_List 2
Sharing 1
sharing documents 1
sheet 1
Sheet Actions 1
Sheet level section access 1
Sheet Trigger 1
Sheet Triggers 2
sheets 1
Sheets order 1
show 2
show all values 1
Show and Hide rows conditionally 1
show hide 1
show last Fiscal QTD in qlikview 1
show last value 1
show percentage 1
show select values 1
Show task execution time within a specified time frame by merging cells of table 1
show. 1
show. no data 1
showing 1
silent install 1
single fact table 1
size 2
slicers 1
slider 3
Slow 2
slowly 1
Slowly Changing Dimensions 3
Slowly Response 1
Smallest 1
SOAP 1
SoapAPI 1
sort 3
Sort by expression 3
Sort order 1
sort weight 1
sort-weight 1
sorting 4
Sorting months 2
Sorting My Objects 1
Sorting of dimensions 1
sorting values 1
SortingIssue 1
sparkline 1
special filter 1
Split 3
SQL 11
SQL Data load 4
sql import 1
sql select 2
SQL Server 1
sql statement 1
SQL-QLIK 1
SSAS Connection 1
SSRS 1
Stacked 1
Stacked Bar 1
stacked bar chart 2
stacked chart 2
standard deviation 2
standards 1
star 1
started_Date 2
STARTRFC 1
statements 1
static 1
Static Max 1
static measure 1
static result 1
Stock 1
Store 6
Store a table in QVD in Server 1
store CSV 1
store procedure 1
STORE QVD 1
Stored Procedure 1
Straight Chart Expressions 4
straight table 33
Straight table and pivot table 3
Straight table custom styling 1
Straight table expression 1
Straight Table Expression Help. 3
Straight Table Total 1
String 5
string functions 1
String to date 1
Strings 1
stringToEscape 1
structure 1
Styles 1
subfield 1
subfield find text 1
Subfield Function 3
subquery 1
subset 1
substring 6
substringcount 1
subtotal 2
Subtotal in Pivot table 1
Subtotals 2
subtract 1
Subtract Rows 1
subversion 1
sum 14
Sum Across Dimensions 1
sum aggr total dimensions 1
Sum conditional 1
Sum Date Ranges 1
sum if 1
SUM IFS 1
Sum of fields 1
Sum Total 2
Sum(if) 1
sumifaggrtosetanalysis 1
Summary Set Expression in Text Object 1
sunny t 3
sunny talwar 3
sunny_talwar 11
support 3
suppress null 1
SuppressZeroValues 1
Surveys 1
svn 1
Swamp 1
swuehl 2
Symbols 1
syntax 3
synthetic key 2
synthetic keys 1
System variables 1
tab users 1
Tabellendiagram 1
table 14
Table Border 1
table box 2
Table chart 4
Table exists 1
table expression 1
Table Field 1
Table Formatting 1
table in message 1
Table Joins 1
table structure 1
Table Viewer 2
table_popingup 1
Table_structure 1
tablebox 2
tables 5
Tables and row counts 1
tables load 1
tabs 1
talend 1
talend open studio 1
Target Table 1
tasks 1
Team 1
Temporary Tables 1
Teradata 1
test 1
text 3
Text box and Chart Subtraction 1
Text Boxes 5
Text Color Expression 1
Text colors 1
Text File 1
text format 1
text input 1
text object 5
Text on charts 1
TextBox 1
Textbox_Action_variable 1
textboxes 1
textboxexpression 1
Textfeld 1
textfile 1
TextObjectActions 1
TextObjectTriggers 1
thumbnail 1
tickets open closed 1
TiedRanks 1
time 4
time between timestamps 1
Time comparison with an existing date-time combined field 1
Time convert 1
time difference 1
time format 1
Time Range 1
TimeDifferencebetween2timestamps 2
Timeline chart 1
timeofday 1
Timeout 2
Timestamp 9
timestamp range 1
TimestampFormat 1
TIMESTMP Conversion 1
To Calculate Yearly buckets 1
today 1
Today Date without Manual Selection in Qlikview 1
toggle 1
Toggle Button 1
Toggle Button ot switch between two dashboards items 1
tolerance 1
top 2
top 10 1
Top 20 1
Top 3 Customers With Sales amout or Top 3 customers by Product Count 1
Top 5 3
top N 5
Top N % 2
Top N value 1
Top N Values 1
top5 1
Total 10
Total Case 1
TOTAL of column 2
TOTAL of column - percentage 2
total row 1
total sales 1
Total straight table click 1
Total sum 1
Totals 2
Totals not working 1
totals pivot table 1
Tranform line to colum 1
transaction 1
transfer state 2
transform 1
Transform and transpose 1
Transpose 1
Transposed Table 1
travel 1
tree 1
tree diagram 1
tree view 1
Trend 2
trend line 1
Trending 1
trigger 3
trigger event 1
Trigger Fail 2
Triggerforlistbox 1
Triggers 21
TriggerWithAlternateState 1
troubleshooting 1
two dimension 1
Two Level SCD 1
two measures 1
txt 4
txt file 1
txtfile 1
Type A Error 1
UI 2
UI slowness 1
Unable to Load Max Year data 1
Unable to reload dashboard using QMC 1
unblanced 1
under water formulas 1
update 2
update qvd 1
upgrade 12.40 1
Upgrade QV12 issue 1
upload 1
upload file with variables columns and transpose 1
Upper Filename 1
urgent 1
URL 4
URL Hyperlink 1
URL selections 1
usage cals 1
usar filtros 1
use of already available expression 1
User Authorization 1
User defined field 1
User interaction 1
user privileges 1
USERID 1
username 1
using two different date fields for calculation of months 1
usuarios 1
utf16 1
utf8 1
UUIDArchivos 1
v12 Qix optimization calculation expressions 1
vacancies 1
vairable schema 1
value 2
Value handling in string 1
Value Handling Variable 4
value ranges 1
value's change 1
Valuelist 1
valueloop 1
values not merged. 1
values on data points 1
varaible 1
varchar(max) 1
variable 18
variable as an argument of another variable 1
Variable Buttons 4
Variable definition 3
variable filter panel 1
variable input 2
Variable Input box 2
variable inputs as deminsions in set analysis 1
Variable value 2
Variable values 3
variable values in if statement 1
Variable values into loop 1
variable. 1
Variables 33
variables with parameters 1
variável 1
VB 1
VB.NET 1
vba 4
VBA CSV Browser 1
vbs 1
VBScript 2
verify filter 1
Version 12.5 1
virtual line 1
Visual Cues 1
Visualizations 2
vlookup 1
Vouhers 1
vUrl 1
web 1
Web Connectors 1
web files 1
Web Server 1
webview 3
Webview mode 3
week 4
week number 1
weekday 1
Weekend 1
Weekend Date 2
weeks 1
weighted average 1
Where 3
Where clause 1
where exists 1
Where Not Exists 2
while 1
while loop 1
whole data 1
Wildcard 1
Wildcards 1
wildmatch 6
Wildmatch () 1
windows checkbox 1
windows server 2016 1
without saving 1
Word 1
Word Table 1
working days 1
Working Hours. 1
workinghours 2
wrap 1
Writeback 1
wöchentlich 1
x-axis 1
X-Y 1
XML 1
XML Parse 1
Year month 1
Year to Date 2
year week 1
Year-Over-Year 2
YearFilter 1
YOY 1
ytd 8
YTD Listbox month names 1
zero values 2
zip file 1

QlikView App Development

Topics with Label: Dual Set Expressions

Using Dual and Concatenate in a Pivot Chart Expres...