QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Apply discount to the product with the lowest valu...

by on Latest post on by

11 Replies 447 Views

11 Replies

447 Views

Labels

"windows tags" 1
'MMM' 1
'peek''do while loop''variable' 1
'set analysis' 1
'set expressions' 1
100% Stacked Bar Chart 1
12.10 1
12.40 1
15 minutes 1
2 values 1
2tables 1
@bill_markham 1
@PavanNallani 1
@Set Analyis 1
@sunny_talwar 2
@Taoufiq_Zarra 1
above 2
Above() function 2
Access Database 1
accesspoint 1
accumulate sum 1
Accumulation 2
ad hoc report 1
add dates to existing table 1
AdditionalColumninExcel 2
Addmonths 1
Advanced Data Visualization book 1
Advanced qlik 1
agent 1
aggr 3
aggr function 1
Aggr or Set Analysis 1
Aggr Sum 1
AGGR() 6
AGGR() ordering 1
aggregate 2
aggregated sum in matching fields 1
aggregation 4
Aggregation in script 1
agrupar 1
Ajax URL 1
allow-nonselect-queries 1
always one selected value 1
ANALISIS 1
and 2
API autentication 1
App Development 2
apply map 1
applymap 14
Applymap() 1
Approximate Match 1
aprender 1
April 2019 2
array 1
ASCII NUL 1
asof 1
associated keys 1
Associative 1
attach report 1
Attachment 1
attributes 1
auto generate 1
Auto Refresh 1
Autofit Coloumns in Excel 1
autogenerate 2
aux varibles. 1
average 2
Azure 1
back fill 1
balance 2
bankaccount 1
bar chart expressions 2
Bar chart with values 1
Basics 1
batch 3
beginner 1
between 2
Binary Load 2
BOM 1
Bookmarks 1
Boolean 2
boolean script chart restrictive 1
Brasil 1
Bucket 2
Bucketing 1
Bundle 1
button 1
ButtonActions 1
Cache 1
CAL 1
calculated 2
Calculated date 1
Calculated dimension 5
calculated dimensions 2
calculated field 1
calculated fields 1
calculation 3
Calculation Condition 1
calendar 6
calendar script 2
calendarweek 1
Cannot open file 1
canonical calender 1
Canonical Date 1
CARGA 2
CarriedForward 1
carryforwardsrequest 1
case 1
case insensitive 1
Character Set 1
chart 5
chart expression 1
chart expressions 1
Chart ID 1
Chart reference lines 1
charts 3
chat 1
circular loop 1
Cleanup 1
Closing 1
Cloud Business 1
CMD 1
Code 2
coding 1
Color condition error 1
Color selection is locked 1
column 1
columnas 1
columns 1
combine QVD 1
combining 1
Combo Chart 1
COMMAND 1
Common time dimension 1
comparative analysis 1
Compare date 1
compare fields script 2
Compare updated data in a field 1
comparison 1
Concat 3
Concat value 1
Concat() 1
concatenate 7
Concatenate 2 Fact tables 1
Concatenate fields 1
Concatenate more rows to one row 1
Concatenate sort bug 1
concatenation 1
condition 1
conditional 1
conditional load 1
conditional sum 1
ConditionalExpressions 1
connect 1
connection error 1
console 1
Constant 1
contains 1
Contract 1
control-flow 1
conversation 1
Conversion 2
Convert table columns into hierarchical structure 1
Convert Unix epoch date time into normal date and vice versa 1
Converting IF condition to Set Expression in qlikview 1
converttolocaltime 1
Count 9
Count Aggr If 1
Count Distinct if 1
Count if 3
Count one Single column on the basis of other Single column & single variable 1
COUNT Parameters 1
Count_days 1
Country Code 1
Create a column with weekdays and All days 1
Create Bandings 1
Create Dates 1
Cross Table 2
cross tables 1
crosstable 5
crosstabs 1
css 1
CSV 4
cte 1
Cummulative 2
cummulative sum 2
cumulation 1
cumulative 4
Cumulative calculation using range sum function 1
cumulative sum 1
cumulative sum in chart 1
Currency 1
current month 1
Current Selection 1
Curso 1
customer 1
cyclic group 1
Dashboard 2
data 7
Data Analytics 1
Data base 1
Data Connection 1
Data Extraction Issue 1
data filtering 1
data import 1
Data inconsistancey in Qlik Script and SqL script 1
data load 2
Data load editor 3
data mining 1
Data Model 4
data modeling 1
Data Modelling 1
data series 1
database 1
database connnection 1
Database Query 1
DataSet 1
datatype 1
Date 21
Date & Time 3
date conversion 1
date field 1
date fields 1
date format 1
date formatting 1
date function 1
Date Functions 1
date in for next 1
date null sqlserver 1
date qlik doubling time script function 1
date range date leadtime 1
Date selection 1
date system 1
date timestamp 1
DATE VALUE 4
datediff 1
dates 9
dates comparison 3
datetime 2
DateTime handling 1
DateTimeformat 1
Datum 1
DAX 1
Dax Query 1
DB connection 1
debug 2
declare 1
default 1
Default Filters 1
delete 1
Deleting values 2
delimiter 1
Delimiters 3
demerits 1
designing 1
Desktop 1
Developer 4
Development 1
diagram 1
difference 2
different columns 1
dimension 4
dimension in pivot 1
Dimensions 6
dimesions 1
Direct Discovery 1
Direct Query 1
discount 1
Distinct 3
Distinct values 1
divide 2
do loop 2
do while 2
Do While Loop 1
document chaining 1
Documentation 1
DocumentPath() 1
doesn't exist 1
Dollar expansion 2
Dollar Sign 2
double mapping 1
drop 1
Dropped Fields 1
dual 1
duplicate 2
Duplicate data 4
duplicate fields 1
Duplicate Rows 3
duplicate values 1
Duplicaterecords 4
duplicates 4
duration 1
dynamic field name 2
dynamic intervals 1
Dynamic selections 1
dynamic tables 1
dynamic variable 1
DynamicColumns 1
elapsedtime 1
email 1
Embed 1
embed labels 1
empty fields 1
enddate 1
Engine 1
Entries 1
epic 1
Error 3
errormode 1
evaluate 1
excel 8
Excel data 3
Excel data sets to Qlik 1
excel loading 2
Excel query 1
Excel via ODBC 1
ExcelSource 1
exclude data 1
Excluding data on LOAD in EXCEL 1
execute 2
Execute Command in Script 1
Exists 6
exit script 1
Expansão $ 1
Export 2
export error 1
Export Script 1
export to csv 1
exporting to csv 1
Expression 22
Expression Error 3
expression in script 1
Expressions 5
ExtraCharacters 1
Extract 1
extraction 1
False() 1
February 2019 1
field 5
Field name 2
field not found 3
field not found error 1
Field renaming 2
Field value 2
fieldname 2
fields 2
fields in a column of data 1
file 3
File name 1
File not found error 1
file-format 1
files 1
filesize 1
filesystem 2
Filter 7
Filter applies 2 fields 1
filter duplicates 1
financial year 1
First value 2
FirstSortedValue 4
FirstSortedValue() 1
firstvalue 2
Fiscal Quaters 1
flag 4
flag count 1
flagging 1
flags 1
float 1
float64 1
floor 2
FolderAccess 1
for 1
for each 1
for loop 6
For loop file store 1
for next 2
Forecast 1
forecast data 1
Forecasts based on last year's figures for the next coming 3 months 1
format 3
format date 2
format error 1
Formating 2
formats 1
formatting 4
Formatting Rules 2
formula 5
formula last year 1
fractile 1
freeze 1
from_field 1
full month 1
Full Outer Join 1
function 9
functions 1
FY20 1
gaps 1
general error 1
generate missing data 1
generating data in QV 1
generic keys 1
Generic Load. 1
GetFieldSelections 1
Governance 1
governance dashboard 1
Grand Total Issue 1
Grant 1
graph correlation 1
Grid sum 1
group 2
group by 6
Group by in Load 4
Group by Interval Time 1
Group by Invalid expression 1
GROUP BY ISSUE 3
header 1
Healthcare 2
Healthcare Fractile Aggr Set analysis 1
hidden 1
Hide and show 1
Hide Prefix 1
hierarchy 5
Hour 1
hours 1
How to calculate the first day of a different status 1
How to create next row in script 1
how to load multiple qvds with different column and successful concatenation without synthetic keys 1
How to show all selected periods in Stright Table 1
HTML 1
https 1
IBAN 1
if 5
IF & OR 1
IF AND STATEMENT 4
if condition 2
If else 1
IF only 1
If stament 1
if statement 11
if statement in load script 1
if statements 1
if statements date 1
If statment 1
If...ElseIf cause 1
IF...THEN 1
Ignorebrackets 1
ignoring rows 1
Illness buckts 1
Import 2
Increment 1
incremental 2
Incremental Load 7
IncrementalLoad 1
Index 2
index table 1
inline 1
Inline Error 1
Inline Load 2
Inline Table 1
inner join 2
Insert 1
insert new row 1
int 1
int64 1
Integer 1
Inter record functions 2
intersection 1
interval 1
Interval Dates 1
Interval Match 2
Interval Match with two tables 1
IntervalMatch 8
IntervalMatch on multiple fields with multiple condition in a table 1
INTERVALMATCH YOY 1
into 1
iseries stored procedures 1
island table 1
Isnotnull 1
IsNull() 1
iso 8601 1
iteration 3
Iterative Calculation 1
iterno 1
Java 1
join 14
JOIN MAPPING 2
Join Query 3
Join Scripting 2
join tables 3
joins 3
JSON 3
JSON API 1
julian 1
keep 3
Key 2
key fields 1
keywords 1
KPI 1
last 30 days 1
last cost 1
Last value 4
lastvalue 1
latest file 1
launch 1
Layout 1
leading 1
Leading zero 1
leading zeros 1
Lectura XML 1
LEF 1
left 3
left join 3
left keep 1
left() 1
LeftJoin 2
let 1
LET SET 1
let statement 1
level 1
libro 1
like 1
limit 1
limitations 1
Limited Load 1
line chart 2
lineitem 1
Link 1
Link Table 1
linking 1
list 2
list box 1
List Box Range Values 1
Listbox 2
load 16
load all files in folder 1
Load Data 19
Load Data distinct 1
load editor 1
load from .txt 1
Load Inline error when missing the final bracket "]" 1
load last value 1
Load Script 18
LOAD SCRIPT CONSUMPTION TABLE 1
Load Script Error 1
Load Statement 1
loading 2
loading data 1
Loading from DB or File at time of Import 1
Loading of Data 1
loading script 1
loading_data 2
loadscript 2
local 1
Log Files 1
logic 1
logic test 1
lookup 4
Loop 17
loop in script 1
loop with multiple condition 2
looping 1
Looping variable script 1
loops 5
Loops and Iterations 2
Macro 8
macro bat 2
Macro export 1
Macro export. 1
Macro System 1
macro-building 1
macros 2
Making Selections 1
mapped drive 1
Mapping 5
Mapping in qlikview 1
mapping load 4
Mapping load with calculated expressions or functions 1
mapping table 2
mapsubstring 2
mark 1
master calendar 4
Master Calendar with Sequence Dates 3
Master calendars 1
Match 2
Match multiple values 1
matching fields 1
matrix 1
max 2
Max Date Value 1
Max Function 2
maximum 1
measure 1
Measure change 1
Median for Expression Total Row 1
merge multiple rows into a row of multiple columns 1
Merge Rows 1
merits 1
Metadata 1
mid 1
Min 1
min value 2
Min() 1
minutes 1
Missing 1
Missing Data 2
missing field 1
Missing Fields 1
missing table 1
Mixed Granularity 1
mode 1
Mode() 1
modeling 1
Modified Store function 1
module editor 1
money 1
Monitoring 1
month 2
Month Difference between 2 dates 1
Month End Dates 1
Month Selection 1
month() 1
monthend 1
MonthEndDate) from previous Year 1
months 1
more sources 1
most recent record 1
move source file 1
Mulitple Values 1
multiple 2
multiple columns 1
multiple conditions 1
Multiple fields 1
multiple keys 1
multiple mapping 1
Multiple Rows 1
multiple sheets 1
multiple sources 2
Multiplication 3
mysql 1
MySQL database 1
NATURALLEFTOUTERJOIN 1
Navision 1
Need work around to populate 1:M values in Apply map and populate as ID instead on Unknown 1
Nested If 3
nested ifs 2
network access 1
new 1
new field 1
New Fields 4
New Qlik Community Design 1
NEW QLIKVIEW 1
New To Qlik 2
New to Qlik Community 2
New to Qlik Sense 1
New to QlikView 14
NewtoQlikView 3
next value 1
nhs 1
noconcatenate 1
Non Matches 1
non-optimized 1
nonconcatenative 1
Not 1
not equal to 1
not exists 1
not fully loading 1
not like 1
not match 1
not null 1
November 2018 Release 1
npv xnpv irregular step payments 1
NTNAME 1
Null 3
Null Display 2
Null value 1
Null values 1
NullCount 1
nullvalues missing 1
num 2
number format 1
number formating 1
number formatting 1
NumberForma 1
numeric fields 1
numerical sequences 1
ODBC 3
OLEDB 2
OMIT 1
One date field with two individual selections 1
One to many 1
only 1
Opening 1
Optimized Load 3
or 1
ORACLE 4
order 1
order by 2
OSUser 1
outer join 1
output 1
p() function 1
pagination 2
paging 2
parameter 1
Parent-child relationships 2
parse 1
Parse string 1
Partial reload 1
pattern 1
Peek 16
Peek () 1
peek() 3
percentage 2
Percentages 1
Performance 3
Performance Dashboard 1
performance issues 1
Period of time 1
Periods 1
Pick(Match()) 1
Pivot Dimensions 1
Pivot Filter 1
pivot table 7
Pivot table chart filter on all possible values in another field 1
Pivot Table Header Columns 1
Pivot Tables 4
Pivot Tables Total 1
pivt tables 1
Planning 1
Plugin 1
postgres 1
PostgreSQL 1
PowerBI 1
PowerTools 1
preceding load 3
Prediction 1
Prepared_Statement 1
presentation tab 1
Previous 8
previous 12 months 1
Previous function 2
previous value 2
Pricing 1
Primary Y 1
Print to PDF 1
PROBLEM Date={"<=$(=max([Date]))"}>} 1
proc 1
Product Hierarchy Dates Problem 1
proportiones 1
provisioning 1
pseudography 1
purge 1
purgechar 1
QAP 1
Qlick 1
qlik 3
Qlik App 3
Qlik Chart Functions 1
Qlik Community 10
Qlik Community Team 4
Qlik Connectors 1
Qlik Core 1
Qlik DataMarket 1
qlik desktop 1
qlik Developers 2
Qlik Explorer for Developers 1
Qlik Load Script 1
Qlik requirement clarification 2
Qlik Scripting 2
Qlik Sence 3
Qlik Sense 8
Qlik Sense App 1
Qlik Sense Scripting 1
Qlik Support 1
qlik view 3
Qlik view ReloadTime() function for SQL function or script 1
QlikBrasil 1
qlikCommunity 1
qliksense 7
qliksense desktop 1
QLIKSENSE FREELANCER 1
Qliksense Scripting 3
QlikView 63
qlikview 11 1
QlikView 11.2 3
Qlikview 12 4
QlikView 12.2 5
QlikView 12.30.20000 2
QlikView App 11
QlikView App Development 22
Qlikview application development 1
QlikView Applications 6
QLIKVIEW Chart 8
QLIKVIEW chart expressions 2
QlikView Connector 1
QlikView dashboard 1
Qlikview Data 1
qlikview design 1
QlikView Desktop 2
QlikView Development 16
QLIKVIEW Dimensions 3
qlikview expressions 6
QlikView Extensions 1
QlikView Features 2
Qlikview for loops 1
Qlikview load 2
Qlikview Macro 1
qlikview management console 1
qlikview output 1
qlikview reload 1
QLIKVIEW Script 44
QLIKVIEW script - Need help in transforming data 1
Qlikview Script Editor Function Pop-up Help 1
QLIKVIEW Script help 16
QLIKVIEW Script help - 5
Qlikview script to pick specific qvds from month 1
QlikView scripting 25
Qlikview Server version is compatabible with installed QlikView Desktop 1
qlikview share folder private 1
QlikView support 1
Qlikview YTD calculation 1
QlikView. 1
qlilkview 1
Qlilsense 1
qliview 1
QMC 2
QMSEDX 1
QTD 1
QUALIFY 1
quarter 1
Quarter Year 1
query 4
Quotes 1
QV12 LoadBalancer 1
QVD 10
qvd files 1
QVD Generator 1
QVD issue 4
QVD Loads 1
qvd to csv 1
QVD to Excel 1
QVD出力 1
QvOdbcConnectorPackage.exe.config 1
QVS 5
qvw 1
qvw files 1
QvWorkPath 1
range 5
Ranges 1
rangesum 6
Rangesum() Function 1
Rank 4
rank function 1
rank() 1
Ranking 2
Ranking on one dimension & one variable 1
ranking qlikview 1
Read column value from table 1
recall the latest record 1
Recarga 1
records 2
Reduction on Multiple Fields 1
Reference Lines 1
refresh 1
regroup 1
relations 1
reload 4
reload engine 1
remove 2
remove duplicates 1
remove_rows 1
removing 1
Rename Field 2
repeat values 1
replace 4
Replace Value 1
resident 3
resident load 3
REST 1
REST API 4
REST API Conection Token 1
REST API Pagination WorldBank API 1
REST Connections 1
restrict view 1
Restriction 1
Retail 1
Retrieve text from a string 1
reversed crosstabs 1
right 3
right Join 1
right() 1
ROLLING SUM 1
Rotate 1
round 1
round function 1
row 1
rowno() 1
Rows 1
Running sum 1
Sales 1
sales analysis 1
same key 1
same values 1
SAP 3
SAP Connector 1
scheduler 2
scrap cost 1
Script 142
script aggregation 2
Script and Expressions 21
Script Debugger 1
script editor 5
Script Error 4
script expressions 1
script function 1
script functions 1
Script level sorting 3
script log 1
Script Logic 12
Script Logic (Visualization) 3
Script Rank 1
Scripting 84
Scripting - Mapping 5
Scripting and Expressions 4
Scripting Current Year calendar(Year 1
Scripting error 1
scripts 1
Search 1
Section Access 4
Section Application 1
Security 2
select 1
selection 1
Selection in multi dimension 1
Selection issue 2
selections 1
Selective Load 1
send email 1
Sequence 3
Sequence Frequency 1
Sequence using Above() 1
Server 1
session Access 1
Set 2
Set Analisys 8
Set analyis 1
Set Analysis 35
Set Analysis Expression 1
Set Analysis Expression. 1
Set Analysis syntax 1
set analysys 1
Set Expression 2
set expressions 2
set_analysis 4
set_modifiers 1
Sharepoint 1
Sheet Filters 1
shift 1
shiftplanning 1
similar tables 1
similares 1
snapshot data 1
Snowflake 1
sort 1
Sort by expression 1
Sort order 1
sort weight 1
sorting 1
special character 1
special filter 1
specific 1
Split 1
Split Field 1
split string text without serating words 2
Split the string with subfield 1
split value 1
SQL 13
SQL Data load 6
SQL Error 1
sql import 1
SQL IN function 1
SQL query background 1
sql select 1
SQL Server 2
SQL Subquery 2
SQL-QLIK 1
SQLServer 1
SR3 1
SR9 1
SSAS 1
Stacked Bar 1
star 1
Start and end time 1
StartDate 1
step 1
Stop interval trend 1
Store 2
store CSV 1
Store Function 4
Store to JSon 1
straight table 5
Straight table and pivot table 1
String 7
String to date 1
Strings 2
stuff 1
subfield 7
Subfield Function 2
Subintervals 1
subquery 1
Subroutine 1
subset 1
substrings 1
Subtotals 3
subtraction columns 1
sum 8
sum expression with If condition 1
sum of values from different rows. 1
Sum Total 1
Sum with If 1
sumif 1
sumifs 2
summary 1
summe 1
SumofValue 1
sunny_talwar 2
swapping in script 1
switch 4
Syntax error 1
Syntax Highlight 1
synthetic key 2
synthetic keys 1
tab 1
table 10
table box 1
Table chart 1
table expression 1
Table Field 1
table functions 1
table not found 1
table null 1
table structure 1
Table Transformation 2
tables 5
tables if columns 1
Tabular Data 1
tags 1
task 1
Testing 1
text 2
text format 1
text to column 1
TextBox 1
textfile 1
The download failed 1
time 4
time comparison 1
Time convert 1
time format 2
time limit 1
Time Overlap 1
time period 1
timeformat 1
Timestamp 8
timestamps 1
Today() 1
top 10 percent 1
Total 6
Total Case 1
Totals 1
trailing 1
transcript 1
transfer field 1
transform 1
Transform and transpose 1
Transformation 2
translate 1
Transpose 5
transpose by only some rows 1
Transposed Table 2
tree diagram 1
tree view 1
trigger 1
triggers. 1
trim 2
trimming the field values 1
True() 1
txt 1
txt file 2
txtfileload 1
UI 1
unc 1
uneven 1
unexpected token 1
union 1
unique 1
unique identifier 1
updated records 1
Upgrade QV12 issue 1
User Authorization 1
user defined function 1
user limitation 1
User Management 1
UTC 2
v12.40 SR1 1
valores 1
value swapping 1
values 2
variable 5
Variable definition 1
Variable values into loop 1
Variables 5
variables with parameters 1
Variablesinsearchobject 1
vba 1
VBScript 5
View 1
View Data 1
viewer 1
Visual Basic 1
Web Clients 1
Web Connectors 1
web scraping 1
week 1
week over week 1
Weekends 1
weeks 1
weirdness 1
Where 6
Where clause 6
where exists 1
where exists() 1
where is empty 1
where isnull 1
while loop 1
Wildcard 2
Wildcards 1
wildmatch 8
windows time 1
WITH CONNECTION 1
xlsx 1
XML 5
XML Parse 1
Year to Date 1
year() 1
yearly 1
ytd 2
Zeitraum 1
zeros 1
複数項目キー 1

QlikView Scripting

Topics with Label: Min

Apply discount to the product with the lowest valu...