Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

by on Latest post by

10 Replies 244 Views

10 Replies

244 Views

Labels

"windows tags" 1
'MMM' 1
'peek''do while loop''variable' 1
2 values 1
2tables 1
above 1
Above() function 1
Access Database 1
Accumulation 2
AdditionalColumninExcel 2
Addmonths 1
aggr 2
aggr function 1
Aggr or Set Analysis 1
Aggr Sum 1
AGGR() 4
aggregate 2
aggregated sum in matching fields 1
aggregation 2
agrupar 1
allow-nonselect-queries 1
ANALISIS 1
and 1
App Development 2
apply map 1
applymap 14
aprender 1
April 2019 2
array 1
asof 1
associated keys 1
Associative 1
attach report 1
Attachment 1
attributes 1
auto generate 1
autogenerate 2
average 2
bankaccount 1
bar chart expressions 2
Basics 1
beginner 1
between 1
Binary Load 2
Bookmarks 1
Boolean 2
boolean script chart restrictive 1
Brasil 1
Bucket 2
Bundle 1
button 1
Cache 1
CAL 1
calculated 1
Calculated date 1
Calculated dimension 4
calculated dimensions 2
calculated field 1
calculated fields 1
calculation 2
calendar 4
calendar script 1
Cannot open file 1
CARGA 2
case 1
case insensitive 1
Character Set 1
chart 4
chart expression 1
chart expressions 1
Chart ID 1
Chart reference lines 1
charts 3
circular loop 1
Cleanup 1
Code 1
coding 1
Color condition error 1
Color selection is locked 1
column 1
columnas 1
combining 1
Common time dimension 1
comparative analysis 1
Compare date 1
compare fields script 1
Compare updated data in a field 1
Concat 3
Concat() 1
concatenate 4
Concatenate more rows to one row 1
Concatenate sort bug 1
concatenation 1
condition 1
conditional 1
conditional sum 1
ConditionalExpressions 1
connect 1
connection error 1
console 1
Constant 1
contains 1
contract 1
control-flow 1
Conversion 1
converttolocaltime 1
Count 7
Count if 3
COUNT Parameters 1
Count_days 1
Create Bandings 1
crosstable 2
crosstabs 1
css 1
csv 1
cte 1
Cummulative 1
cummulative sum 1
cumulative 3
Cumulative calculation using range sum function 1
cumulative sum in chart 1
Currency 1
current month 1
Curso 1
cyclic group 1
data 4
Data Analytics 1
Data connection 1
data import 1
Data inconsistancey in Qlik Script and SqL script 1
data load 1
Data load editor 3
data mining 1
Data Model 3
data modeling 1
Data Modelling 1
database 1
Database Query 1
DataSet 1
datatype 1
Date 13
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 system 1
date timestamp 1
DATE VALUE 3
datediff 1
dates 8
dates comparison 3
datetime 2
DateTime handling 1
DateTimeformat 1
Datum 1
DAX 1
DB connection 1
debug 1
declare 1
Delete 1
Deleting values 1
Delimiters 2
demerits 1
designing 1
Desktop 1
Developer 3
Development 1
diagram 1
difference 1
different columns 1
dimension 4
dimension in pivot 1
Dimensions 6
dimesions 1
discount 1
Distinct 2
Distinct values 1
divide 2
do loop 2
do while 2
Do While Loop 1
Documentation 1
DocumentPath() 1
Dollar expansion 2
Dollar Sign 2
double mapping 1
Dropped Fields 1
dual 1
duplicate 2
Duplicate data 3
duplicate fields 1
Duplicate Rows 2
duplicate values 1
Duplicaterecords 3
duplicates 3
duration 1
dynamic field name 1
dynamic intervals 1
Dynamic selections 1
dynamic tables 1
dynamic variable 1
DynamicColumns 1
elapsedtime 1
email 1
Embed 1
embed labels 1
enddate 1
Engine 1
epic 1
Error 1
errormode 1
evaluate 1
excel 8
Excel data 2
Excel via ODBC 1
ExcelSource 1
exclude data 1
execute 1
Execute Command in Script 1
exists 3
export 2
export error 1
Export Script 1
export to csv 1
Expression 17
Expression Error 2
expression in script 1
Expressions 3
ExtraCharacters 1
Extract 1
extraction 1
False() 1
February 2019 1
field 4
Field name 1
field not found 2
field not found error 1
Field renaming 1
Field value 1
fieldname 1
fields 2
fields in a column of data 1
file 2
File name 1
File not found error 1
file-format 1
filesize 1
filesystem 2
Filter 6
First value 2
FirstSortedValue 2
FirstSortedValue() 1
firstvalue 2
flag 2
floor 2
FolderAccess 1
for 1
for loop 5
for next 2
Forecast 1
forecast data 1
Forecasts based on last year's figures for the next coming 3 months 1
format 2
format date 2
format error 1
Formating 1
formats 1
formatting 2
Formatting Rules 2
formula 5
formula last year 1
freeze 1
full month 1
function 5
gaps 1
general error 1
generating data in QV 1
Generic Load. 1
GetFieldSelections 1
Grant 1
graph correlation 1
group 1
group by 4
Group by in Load 2
Group by Invalid expression 1
GROUP BY ISSUE 1
Healthcare 2
Healthcare Fractile Aggr Set analysis 1
hidden 1
Hide and show 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 show all selected periods in Stright Table 1
HTML 1
https 1
IBAN 1
if 4
IF AND STATEMENT 3
if condition 1
If else 1
If stament 1
if statement 9
if statement in load script 1
if statements 1
If statment 1
If...ElseIf cause 1
Ignorebrackets 1
Import 2
incremental 1
Incremental Load 5
Index 1
index table 1
inline 1
Inline Error 1
Inline Load 2
Inline Table 1
inner join 1
insert new row 1
Inter record functions 2
intersection 1
Interval Match 1
Interval Match with two tables 1
IntervalMatch 5
IntervalMatch on multiple fields with multiple condition in a table 1
into 1
iseries stored procedures 1
island table 1
Isnotnull 1
IsNull() 1
iso 8601 1
iteration 3
Iterative Calculation 1
Java 1
join 11
JOIN MAPPING 1
Join Query 3
join tables 2
joins 3
JSON 2
JSON API 1
julian 1
keep 1
Key 1
keywords 1
KPI 1
last 30 days 1
last cost 1
Last value 4
lastvalue 1
launch 1
Layout 1
leading 1
Leading zero 1
Lectura XML 1
LEF 1
left 3
left join 2
left keep 1
left() 1
LeftJoin 2
let 1
level 1
libro 1
like 1
limitations 1
Link 1
Link Table 1
linking 1
list 1
list box 1
List Box Range Values 1
Listbox 2
load 13
load all files in folder 1
Load Data 12
load editor 1
load from .txt 1
Load Inline error when missing the final bracket "]" 1
load last value 1
Load Script 13
LOAD SCRIPT CONSUMPTION TABLE 1
Load Script Error 1
Load Statement 1
loading 1
loading data 1
Loading from DB or File at time of Import 1
loading script 1
loading_data 2
loadscript 1
local 1
Log Files 1
logic 1
logic test 1
lookup 3
Loop 10
loop in script 1
loop with multiple condition 2
Looping variable script 1
loops 4
Loops and Iterations 2
Macro 8
macro bat 2
Macro export 1
Macro export. 1
macro-building 1
macros 2
Making Selections 1
mapped drive 1
Mapping 4
mapping load 3
mapping table 2
mapsubstring 1
master calendar 3
Master Calendar with Sequence Dates 2
Match 2
Match multiple values 1
matching fields 1
Max Date Value 1
Max Function 2
measure 1
Measure change 1
Median for Expression Total Row 1
merge multiple rows into a row of multiple columns 1
merits 1
mid 1
Min 1
min value 2
Min() 1
minutes 1
Missing 1
Missing Data 2
missing field 1
Missing Fields 1
mode 1
Mode() 1
Monitoring 1
month 1
Month Selection 1
monthend 1
more sources 1
move source file 1
Multiple fields 1
multiple keys 1
multiple mapping 1
Multiple Rows 1
multiple sheets 1
multiple sources 2
Multiplication 3
Need work around to populate 1:M values in Apply map and populate as ID instead on Unknown 1
Nested If 2
nested ifs 2
network access 1
new field 1
New Fields 4
New Qlik Community Design 1
New To Qlik 2
New to Qlik Community 1
New to Qlik Sense 1
New to QlikView 10
NewtoQlikView 3
next value 1
nhs 1
noconcatenate 1
non-optimized 1
not equal to 1
not fully loading 1
not like 1
not null 1
November 2018 Release 1
npv xnpv irregular step payments 1
NTNAME 1
Null 2
Null Display 2
Null value 1
null values 1
num 1
number format 1
Number formating 1
numeric fields 1
numerical sequences 1
ODBC 3
OLEDB 2
OMIT 1
One to many 1
only 1
Optimized Load 3
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
Peek 9
peek() 3
percentage 2
Percentages 1
performance 2
Performance Dashboard 1
performance issues 1
Periods 1
Pick(Match()) 1
Pivot Filter 1
pivot table 6
Pivot table chart filter on all possible values in another field 1
Pivot Tables 4
Pivot Tables Total 1
pivt tables 1
Plugin 1
postgres 1
PostgreSQL 1
PowerTools 1
preceding load 3
Prediction 1
Prepared_Statement 1
presentation tab 1
Previous 4
previous 12 months 1
Previous function 1
previous value 2
Pricing 1
Primary Y 1
Print to PDF 1
proc 1
Product Hierarchy Dates Problem 1
proportiones 1
provisioning 1
pseudography 1
QAP 1
qlik 2
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 6
Qlik Sense App 1
Qlik Sense Scripting 1
Qlik Support 1
qlik view 2
QlikBrasil 1
qlikCommunity 1
qliksense 6
qliksense desktop 1
QLIKSENSE FREELANCER 1
Qliksense Scripting 3
QlikView 45
qlikview 11 1
QlikView 11.2 3
Qlikview 12 4
QlikView 12.2 5
QlikView 12.30.20000 2
QlikView App 10
QlikView App Development 19
Qlikview application development 1
QlikView Applications 6
QLIKVIEW Chart 1
Qlikview Data 1
qlikview design 1
QlikView Desktop 2
QlikView Development 10
QLIKVIEW Dimensions 1
qlikview expressions 5
QlikView Extensions 1
QlikView Features 2
Qlikview for loops 1
Qlikview load 1
Qlikview Macro 1
qlikview management console 1
qlikview output 1
QLIKVIEW Script 8
Qlikview Script Editor Function Pop-up Help 1
QLIKVIEW Script help 5
QlikView scripting 21
Qlikview Server version is compatabible with installed QlikView Desktop 1
qlikview share folder private 1
qlilkview 1
Qlilsense 1
QMC 2
QMSEDX 1
QTD 1
QUALIFY 1
Quarter Year 1
query 2
QV12 LoadBalancer 1
qvd 6
qvd files 1
QVD issue 3
qvd to csv 1
QVD出力 1
QvOdbcConnectorPackage.exe.config 1
QVS 5
qvw 1
qvw files 1
QvWorkPath 1
range 2
rangesum 4
Rank 2
rank function 1
rank() 1
Ranking 2
ranking qlikview 1
Recarga 1
records 1
Reduction on Multiple Fields 1
Reference Lines 1
refresh 1
relations 1
reload 3
reload engine 1
remove 2
remove duplicates 1
remove_rows 1
removing 1
Rename Field 1
repeat values 1
replace 3
resident 2
resident load 3
REST API 2
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() 1
ROLLING SUM 1
Rotate 1
round 1
round function 1
rowno() 1
Rows 1
Sales 1
sales analysis 1
same key 1
same values 1
SAP 2
SAP Connector 1
scheduler 1
Script 98
Script and Expressions 19
script editor 4
Script Error 3
script expressions 1
script function 1
script functions 1
Script level sorting 2
script log 1
Script Logic 6
Script Rank 1
Scripting 65
Scripting - Mapping 4
Scripting and Expressions 3
scripts 1
Search 1
Section Access 2
Security 1
select 1
selection 1
Selection in multi dimension 1
Selection issue 2
selections 1
Selective Load 1
send email 1
Sequence 2
Sequence Frequency 1
Sequence using Above() 1
Server 1
session Access 1
Set 1
Set Analisys 8
Set Analysis 26
Set Analysis syntax 1
Set Expression 1
set expressions 2
set_analysis 4
set_modifiers 1
Sharepoint 1
similar tables 1
similares 1
snapshot data 1
Snowflake 1
sort weight 1
sorting 1
special character 1
special filter 1
specific 1
split string text without serating words 1
Split the string with subfield 1
SQL 8
SQL Data load 5
SQL Error 1
sql import 1
SQL IN function 1
SQL query background 1
sql select 1
SQL Server 1
SQL Subquery 2
SQL-QLIK 1
SQLServer 1
SSAS 1
star 1
Start and end time 1
StartDate 1
step 1
store 2
store CSV 1
straight table 5
Straight table and pivot table 1
String 2
Strings 2
stuff 1
subfield 4
Subfield Function 1
Subintervals 1
subquery 1
Subroutine 1
subset 1
substrings 1
Subtotals 3
subtraction columns 1
sum 5
sum expression with If condition 1
Sum with If 1
sumif 1
sumifs 2
summe 1
SumofValue 1
sunny_talwar 2
swapping in script 1
switch 3
Syntax error 1
Syntax Highlight 1
synthetic key 2
tab 1
table 7
table box 1
table structure 1
Table Transformation 1
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 3
time comparison 1
time format 2
time limit 1
Time Overlap 1
Timestamp 6
top 10 percent 1
Total 4
trailing 1
transform 1
Transformation 2
translate 1
Transpose 1
transpose by only some rows 1
tree diagram 1
tree view 1
trigger 1
trim 2
trimming the field values 1
True() 1
txt file 2
UI 1
unc 1
uneven 1
unique 1
updated records 1
Upgrade QV12 issue 1
user defined function 1
user limitation 1
User Management 1
v12.40 SR1 1
valores 1
value swapping 1
values 2
variable 4
Variables 4
Variablesinsearchobject 1
vba 1
VBScript 5
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 3
Where clause 5
while loop 1
Wildcard 2
Wildcards 1
wildmatch 5
windows time 1
WITH CONNECTION 1
xlsx 1
XML 3
Year to Date 1
ytd 2
Zeitraum 1
zeros 1
複数項目キー 1

QlikView Scripting

Topics with Label: Min

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