Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Aggr Count Distinct function

2 Replies 60 Views

2 Replies

60 Views

Dúvidas sobre Distinct na expressão

by on

7 Replies 99 Views

7 Replies

99 Views

Sum by Order Number with multiple dates

by on

5 Replies 87 Views

5 Replies

87 Views

Load only Max Date per Application Number

by on

1 Reply 79 Views

1 Reply

79 Views

How to use Count and Distinct function together in...

by on

4 Replies 113 Views

4 Replies

113 Views

Labels

"colour" "bar chart" 1
"gamma distribution" "passwords" 1
% of Total 1
'comment field' 1
'comment table' 1
'Sense' 'Install' 'Windows 16' 1
.qvf file 1
.qvf file error 1
.qvf file not opening 1
20% 1
404 Error 1
6 1
<dimension> 1
AAI 2
above 6
access 3
Access denied 2
access issue 1
access rule 1
Access to a particular group by using binary load in server 1
AccessToken 1
account 1
accumulated sum 2
accumulative line in combo chart 1
Actions Bookmarks Dates 1
Active Directory 2
actual currency rate from National Bank 1
Actualizacion 1
add data 1
add user to app (Qlik Sense Server) 1
addyears 1
Admin 1
Advanced Analytics Toolbox 1
aggr 10
aggr function 2
aggr if 1
Aggr or Set Analysis 2
AGGR() 9
aggregate 3
aggregation 5
aggrigation 1
Alternate States 7
Analysis 3
Analysis Services 1
Analyzer 1
angular 1
annotations 1
Anonymous users 1
API 7
app 2
app published date 1
appear 2
application 1
Application import error 1
applymap 2
Applymap() 2
apps 2
area 1
area layer 2
arquitetura 1
array 2
ASCII 1
ASCII to char 1
asignar proyecto 1
asof 1
asset 1
Association 2
association reccomendation 1
associations 2
Associative 1
Atlassian 1
audit 1
authentication 3
authorization 1
autofill 1
automise 1
Autozooming in Qlik Sense 1
availability 1
Averag of weekdays 1
average 4
average formula 1
average of quartile 1
avg 3
avg daily 1
axis 1
Azure 1
background 1
background color 1
backup 3
backup and restore 1
banco de dados 1
bar 2
bar chart 16
Bar Chart 2 dimensions relative percentage stack 1
bar chart expressions 2
barchart 7
basic authentication 1
basket 1
below target positive 1
Best Practices 1
between 2
between two dates 1
binary chart 1
Binary Load 2
binary signal 1
blank 2
bookmark 1
bookmarks 2
Bootstrap 1
BOT 1
box filter YTD 1
BreakEven 1
browser 1
Brushing 1
btp 1
bubble 1
bubble layer 1
Bucket 1
bug 3
Business Intelligence 1
button for navigation 1
Button to select Field 1
by 1
Cache 1
Calculated dimension 3
calculated field 5
calculating 1
calculating age 1
calculating dates 1
calculation 1
Calculation Condision 1
calculation of avg by excluding of certain numbers 1
Calculation of Rolling period by 8 weeks to get the sum of appropriate measure 1
calculations 1
calendar 10
cantidad 1
capability api 1
Carga com o arquivo atual 1
category 1
cell 1
cell value 1
cells 1
celula tabela data 1
certification 2
change 1
Change Name Dimension Maps 1
changing title colors 1
char 2
characters 1
chart 16
Chart bar 2
chart expressions 2
chart function 1
chart interaction 1
charts 9
check 1
child 1
chrome 1
claims data financial data 1
cleansing 1
clear 1
ClearAllTrigger 1
ClearFields 1
cohort 1
Collapsible Dimension 1
Color 11
color area layer 1
color by expression 5
Color condition error 1
coloring 1
ColorMix 1
Colors 1
colour 1
colour by expression 1
column 2
column order 1
columns 1
combi diagram 1
combined chart 2
Combo Chart 6
Community Help 1
comparative analysis 1
compare 3
Compare Field with other Field in same dimension 1
comparison 2
comparison between months 4
Competitive analysis 1
complex measure 1
Concat 1
concatenat 1
concatenate 2
condition 1
conditional 2
conditional collor 1
conditional display 1
Conditional formatting 2
conditional group 1
conditional sum 1
conditional sum with variables 2
ConditionalExpressions 5
Conditions 1
conector web 1
configuration 1
Connecting to QlikSense via .NET SDK 1
connection 6
connection error 1
connection lost 2
connection string 1
connections 2
Connector 2
Connectors 2
container 1
contar 1
context 1
conversion table 1
copy 1
Count 18
count count it 1
Count if 5
Count if condition 3
count if null 1
Count with If condition 1
count words 2
count() 3
counter 1
counting 1
counting words 1
Countries 1
create new app 1
Creating Relations between two tables in a Load Script Editor 1
Credentials 1
Cross Table 2
crosstable 4
Crosstable(transforming of table) 1
css 1
Cummulative 1
cumulative 2
Cumulative summation by dimensions 3
current cell value 2
current month 1
Current Selection 1
custom 1
custom chart 1
custom markers 1
custom region 1
Customers bought 1
Customize 1
customized calendar 2
cut 1
CVS 1
cyclic dimension 1
d3 1
Dashboard 2
dashboard bundle 2
Dashboard Extension Bundle 2
data 12
data affected in one filter only. 1
data connections 2
data format 1
Data From folder 1
data load 10
Data load editor 12
data load problem 1
data loading 2
Data Model 3
Data Preparation 1
Data Presentation 1
data transformation 1
data validation 2
database 4
Database Query 1
Datamanager 1
Datamodel 1
datapoint 1
DataSet 1
DataWarehousing 1
Date 28
Date Bucket 1
date dimension 1
Date filter 5
date groups 1
date picker 2
Date Range 7
Date set 2
Date time 1
DATE VALUE 2
Date Variable 2
Datefield not recognized as Date 1
dates 5
Datum 1
day(today()) 1
days 1
DB2 1
DCom server process 1
de couple 1
Deall 2
default value 1
defining geography 1
Delete 1
delimiter 1
demension limit 1
demo 1
depreciation 1
derrive 1
descending 1
Desktop 5
Details 1
Dev Hub 1
Developer 1
Development 1
dimension 8
dimension label 2
dimension limit 1
Dimension of stacked & grouped bar chart 2
Dimensiones 1
Dimensions 12
Direct Query 1
disable chart interaction 1
display 1
Display label 1
Distinct 5
distribution plot 2
Division by Variable 1
do while 3
Document Analyser 1
Dollar expansion 2
Dollar Sign 2
Dollarexpression 1
dots 1
double counting 1
down 1
Download 1
drill down 4
drill down charts 1
Drill-Down 6
Drilldown 3
drop table 1
dual 1
dual function 1
Duplicate data 2
duplicate records 1
Duplicate Rows 1
duplicates 1
dynamic 3
dynamic label 2
Dynamic selections 1
dynamic title 1
dynamic update 1
dynamic URL 1
dynamic variable 1
ecuation 1
Embed Sheet 1
Embedded 1
embedding 1
empleados 1
Engine 1
engine api 2
enigma.js 1
enterprise 2
equal 1
Error 9
error log 1
Error ORA-01456 Qlik Sense 1
ErrorCode: 4294967192 1
ETL 1
Events 2
exact 1
exact match 1
exact string position 1
Example AAI QVF FIles 1
excel 10
Excel data 3
excel export 1
Excel Exports 1
excel file 1
excel worksheets 1
exclude 1
exclude data 1
exclude legend 1
Excluded Values 1
exists 1
Expand 1
Expandissue 1
export 3
Export ContextMenu 1
export data 4
Expression 19
expression by color 1
Expression Error 2
Expressions 14
Extension 10
Extension Objects 3
Extensions 9
facts 1
fail to install the latest version of sense on entreprise PC may be because of entreprise network security policy which inhibits some ports 1
family 1
field 2
Field Load 1
Field name 1
field not found 1
fields 3
figures 1
file 1
Filter 19
Filter by Data Types 1
Filter DataSource 1
Filter Dates 1
Filter dimension measure 1
filter not working 1
filter pane 9
filter panel 2
filter pivot 1
filtering 3
filtering NULL values 1
filterpane 4
filters 3
Firewall 1
First value 2
FirstSortedValue 4
fitness 1
FIXED DIVISION 1
flag 2
flags 1
font color 1
for loop 2
format 3
format date 2
formatting 3
fractile 1
framework 1
Freelancer 2
Frequency 1
From Folder 1
full 2
fullscreen 2
function 4
functions 4
funnel 2
funnel chart 1
fusion chart 1
future cash flows 1
gantt 1
Gantt chart 2
gauge 1
gauge chart 1
Gauge chart (street light) 1
Generating Months 1
generic load 1
geoanalytics 1
geographic polygons 3
GeoMapping 1
GeoPop World Map 1
GetSelectedCount 1
Getting Started Webinar 5
Global Grouping 1
Global Variables 1
google analytics 2
google sheets 1
Governance 1
governance dashboard 1
Graph 6
graphics 1
greater than equal to 1
greater than in measure 1
group 2
group bar chart 1
group by 1
group dimensions 1
group nodes 1
Grouped Bar Chart 1
groups 1
growth rate 1
hardcode expression qliksense KPI 1
hardcoded value KPI expression qliksense 1
header 2
header authentication 1
Header collumn Pivot 1
HealthCare 1
heirarchy 1
help 4
hic 1
hide 1
hide columns 2
hide legend 1
hide nulls 1
hide row 1
HideExpression 1
hierarchy 3
highlight 2
history 1
hover 2
html page 1
HTTP 1
hub 1
Hub error 1
Hyperlink 2
Ideas 1
IE 2
if 7
IF & OR 4
if clause 3
if expression 3
if statement 8
iframe 5
ignore month 1
iis server 1
image 1
Implicit set analysis 1
Import 1
Import data R 1
Incremental Load 6
independant selection 1
Indirect Selections 1
initializing add data 1
inline 2
inner join 1
input box 1
Input Parameter 1
install 2
Installation 6
Integration 1
Internet 1
Internet Explorer 1
interpreting 1
interval 1
invite the user 1
ipad 1
ipaddress 1
iphone 1
iseries 1
IsNull() 1
item data 1
iterno 1
javascript 1
join 11
Join Query 1
JSON 3
Just for info 1
KDA 1
keep 1
Key Driver Analysis 1
KPI 6
KPI Chart 4
KPI percentage 1
kpi's 2
label 3
labels 4
Language of Qlik Sense Data loader 1
languages 1
last 1
last 30 days 1
Last date 1
latest 1
Layer 1 1
Layout & Visualizations 1
LDAP 1
LEF 1
left 1
left join 2
legend 2
legend interaction 1
legends 1
let 2
LET using where clause 1
Licence 1
licence management 1
License 1
like 1
line chart 14
Line Chart requirement 1
line offset 1
LineChartExpression 1
linest_b 1
linest_m 1
linestring 1
Link 4
Linking table 1
load 5
Load Balancing 1
Load Data 7
Load Script 15
Load Script Error 2
loading data 3
loading_data 1
location issue 1
Log Files 1
logging 1
Logics 2
Login 1
Login help 1
Looking for a new BI tool 1
lookup 1
Loop 1
lost 1
lower 1
ltd 1
Mail Merge Qliksense Template 1
maiorvalorhorahora 1
Management 1
map 6
Map chart 4
Map Visualization 10
MapBubble Size 1
Mapping 1
Maps 6
maps qlik sense data 1
MapSubString only distinct value 1
mapusing 1
markers 1
mashup 2
Mashups 4
master calendar 6
master dimension 1
master dimensions 1
Master Items 3
MAT 1
Match 2
max 1
max (date) 2
max date 3
max date data 1
max date per month 3
max days 1
Max Function 3
max operator 1
mayor a menor 1
measure 2
Measure Details 1
Measure Expression 1
measures 5
Measures expressions 2
Media library 1
medidas 1
menor a mayor 1
menu 1
merge 1
Merging-joining Data from different fields into 1 field 1
Metadata 1
MIgration 1
min value 1
Missing 2
missing connections 1
Missing Data 1
missing records 1
missing table 1
Misssing months 1
model 1
money 1
mongo 1
mongodb 1
Monitoring app issue 2
Monitoring apps 1
month 3
month - 1 1
month sum 1
MonthToDate 1
More than one Primary key in two tables. 1
Mouseover label 2
moving total 1
MTD 1
multi language 1
multi-node 2
multiple 1
multiple conditions 1
multiple data sources 1
multiple dimensions 2
multiple lines 1
multiple measures 1
multiple values for expressions 1
Multiplication 2
Name with spl chctrs 1
NarrativeScience 1
Navigation 1
negative duration 1
nested ifs 3
new 1
New Feature 1
New Qlik Sense November 2018 2
New To Qlik 6
New to Qlik Sense 51
new to qliksense 4
New to QlikView 3
newbie 2
newbie problem 1
NewtoQlikView 1
no associations 1
no selections applied 1
not as Admin in QMC 1
not in 1
Not saving 1
notification 1
notMatch 1
November 2018 3
November 2018 Release 2
NPrinting 5
Nprinting on demand 1
NTLM 1
Null 2
Null value 2
null values 2
Nulls 1
num 1
Num function 1
number 2
number format 2
number formatting 1
Numberformat 1
numero 1
objects 2
Obter a relação de usuários do Active Directory 1
ODAG 2
odata 1
ODBC 1
ODBC Progress Connection 1
ODBC SQL 2
offline sharing 1
OMIT 1
omkarvamsi 1
On Demand 1
OnetoManyMap 1
OnetoManyMapping 1
only measures 1
open pdf link 1
Operation Monitor 2
OPTIMIZATION 1
Optimized Load 1
ORACLE 1
orden 1
ordenar 1
order 1
order by 1
ordinal variable 1
origin 1
outer join 1
OuterJoin 1
overwrited 1
page 1
pagination 1
paging 3
parameter 1
parse 1
password 1
PASTE 1
path 1
pathfile 1
PDF 1
Peek 2
PEEK as expression 1
percentage 4
Percentages 3
Percentile 1
PercentRank 1
performance 4
performance issues 4
permissions 2
persistent colors 1
picasso 1
pick 1
Pick(Match()) 1
picker data 1
pie 1
pie chart 3
PIovt table 1
pivot 12
Pivot Filter 2
pivot table 22
pivot table colour dimension 1
Pivot Tables 10
placeholder 1
plateau 1
Populate Column Data 1
Ports 1
Possible values 1
Post installation 1
postcode 1
postgres 3
PostgreSQL 3
powerpoint 1
PowerPoint Report 1
powershell 1
preview 1
Previous 2
previous month 2
previous month data 1
previous value 1
problem 1
problema con aggr 1
products that crossed $1000 for the first time 1
proxy 1
publish story 1
Publishing 1
put 1
QDF 1
qdt component 1
qlik 8
Qlik Academic Program 2
Qlik Certification 1
Qlik Cloud 1
Qlik Community 21
Qlik Community Team 4
Qlik Connectors 1
Qlik Deployment Framework 1
qlik desktop 2
qlik Developers 12
Qlik for Linux 1
Qlik Geo Analytics Map - default position 1
Qlik GeoAnalytics 1
qlik import 1
qlik logging service 1
Qlik Logging services 1
Qlik Management Console 1
Qlik NPrinting 1
Qlik Sence 15
Qlik Sense 205
Qlik Sense App 12
qlik sense apps failed to import 1
Qlik Sense Cloud 6
Qlik Sense Desktop 22
Qlik Sense Enterprise 13
Qlik Sense Enterprise Noviembre 2018 1
Qlik Sense Enterprise September 2018 1
Qlik Sense Febuary 2019 1
Qlik sense hub 2
Qlik Sense Install Issues 1
Qlik Sense June 2018 1
Qlik Sense November 2018 5
Qlik Sense RestConnectors Share point application Static response 1
Qlik Sense Scripting 10
Qlik Sense Section Access 2
Qlik Sense Security 1
Qlik Sense Server 5
qlik sense server nprinting bat html 1
qlik sense service error 1
Qlik Sense Setup 1
Qlik Sense Table 4
Qlik Sense Timeline Chart using the Google Chart API 1
Qlik sense upgrade 1
qlik view 2
Qlik- Merge two dashboard through HUB 1
qlik-sense 1
Qlik_Support_Portal_Issue 1
qlikcore 1
qliksense 121
Qliksense & R 2
qliksense administration 1
Qliksense API Calls 2
Qliksense cloud 5
Qliksense Deployment 4
Qliksense development 3
QlikSense Management Console 8
QlikSense Master Calendar 1
QlikSense Mobile certificate 1
Qliksense Script QVD 3
Qliksense Scripting 12
qliksense server 10
qliksense table 2
qliksense web 4
QlikServerSideExtensions 1
Qlikview 6
QlikView App 4
QlikView App Development 6
QlikView Connector for Salesforce 1
qlikview deployment 1
QlikView Desktop 1
qlikview expressions 1
QlikView Hero's 2
QlikView scripting 5
qlikview Visualization 1
Qlilsense 1
Qliq Sense 1
QMC 6
qmc access 1
QRS 6
qrs api 3
QS Variable button 3
qsSimpleKpi 1
qsvariable 1
QTD 1
query 2
qvd 2
QVD issue 3
qvf 1
QVX_UNEXPECTED_END_OF_DATA 1
R 2
range 3
rangeavg 1
rangemax 1
rangesum 13
Rank 5
Rank FirstSortedValue 1
Ranking 3
react 1
Real Time 1
recent date 1
Red format 1
Reduction on Multiple Fields 1
redundant data 1
Reference line 1
refresh 1
Region map 1
regression 1
Related Products 1
relations 1
reload 2
reload task failure 1
Reloads task fail 1
render 1
renewalfind 1
reparto de gastos 1
repeated customer logic 1
replace 1
Reporting 1
Repository service 1
require.js 1
reset 1
resident 1
resident load 1
resize 2
REST 5
REST API 2
REST Connections 1
restore 4
restrict data to Quarter 1
restrict view 1
restricted criteria 1
RGB 1
right 2
right format of numbers 1
Right sharing of fields 1
roles 1
Rolling 12 months 1
Rolling Average 1
rowno() 1
Rows 1
Rserve 1
RunAs 1
Running Total 1
Running totals 1
sales quantity 1
salesvalue 1
same fields 1
same value 1
sample 1
sample BRD 1
sankey 1
scalability 1
Scatter chart 2
scatter plot 1
scatterplot 1
scientific notation 1
screen 2
Script 24
Script and Expressions 6
script data loading generation column order 1
script editor 1
script expressions 1
Script level sorting 1
script log 1
Scripting 13
Search 1
search string in string 1
second occurrence 1
Section Access 10
Section access & Data model 1
Sectionaccess 1
Sections 1
Security 6
security rule 6
security rules 3
Selecciones 1
selection 4
selection box 1
Selection in multi dimension 1
Selection issue 1
selections 4
selective values in filterpane 1
selector 1
SelfService BI 1
sence 1
sense 22
Sense Extension drag & drop error 1
sense hub 1
sensitive sharing of content with subfield()-funktion 1
seperate 1
Sequence 1
Server 3
Session duration in QlikSense 1
Set 3
Set Analisys 8
Set Analyse 1
Set Analysis 62
Set Analysis syntax 5
Set Expression 6
set expressions 12
set modifier 1
set-analysis 1
set_analysis 7
set_modifiers 3
setAnalysis 1
Shapley Regression 1
share 2
share bookmark 1
Share button 1
Sharepoint 3
sheet 3
Sheet Navigation and Actions 1
sheets 1
shifting 1
show hide 1
similar words 2
single date 1
single date typing 1
Single QVD 1
single-node 1
Slash script 1
slider 1
Slider saving input 1
SMTP Connector 1
socket 1
sort 1
Sort by expression 2
sorting 3
Sorting months 2
Sorting of dimensions 2
sorting pivot table 1
sorting pivot table by load order 1
Sorting RowNo 1
sorting values 1
sound 1
sounds 1
SQL 7
SQL Server 1
SQLServer 1
SSE 1
stacked bar chart 3
StackedBarGraph 2
statistics 1
step chart 1
Stock turnover 1
Store a table in QVD in Server 1
storing images 1
Story 2
straight table 3
Straight table and pivot table 3
Stream only for users 1
streams 2
String 5
string function 1
structure 1
subfield 1
Subfield Function 1
subset 1
subtotal 1
Suggestions 1
sum 13
sum if sting 1
sum of max 1
sumif 1
Summarization Problem in Dynamic Table 1
summation of max values 1
sunny_talwar 6
surendraj 1
synchronized script 2
syntax 3
synthetic key 1
Tabela 1
tabla 1
table 12
Table alias 1
Table chart 2
table color format 1
table expression 2
Table Headers With Background Color 1
table of words 1
Table Transformation 1
tablechart 1
tables 10
task 2
task failed 2
task scheduling 1
Technical Preview 1
test 1
text 2
text box 2
textandimage 1
TextBox 1
TextObjectActions 1
Textwrap not working 1
the best way of date comparison 1
The User is not able to duplicate the app in Qlik Sense Server 1
thumbnail 2
tif 1
time 3
time comparison 1
time exceeded 1
time format 1
time-aware charts 1
time-out 1
timeline 2
Timestamp 7
titles 1
to compare datefields with each other (inkl. string) 1
today 4
today()+7 1
Toggle Button ot switch between two dashboards 1
tokens 2
tooltip 2
tooltip custom 1
top 1
top N 1
top5 2
Total 6
total lines 1
total value 1
Totals 1
trailing 1
Training 1
transform 1
Transpose 1
trellis 1
Trend 1
trim 1
Two table 1
Type drilldown 1
TypeError 2
UDC 3
UNAUTHORIZED 1
union 1
unique identifier 1
unlink 1
Unpacking Files 1
unstructured 1
until 1
up and down arrow 1
update 1
Update field value. 1
Upgrade 4
upper 1
urgent 8
URL 2
US county 1
US state 1
Usability 1
Usage Tracking 1
use of extensions 1
use previous month 1
user access 2
User Directory Connector 2
User IP 1
user profile 1
User Stories 1
Users 3
value 1
value description 1
value splitting 1
Valuelist 1
values 1
variable 8
variable filter panel 2
variable input 1
variable inputs as deminsions in set analysis 1
Variables 12
Version Control 1
Versions 1
views 1
virtual proxy 1
visualization 2
visualization time series forecasting 1
Visualizations 1
Vizlib 1
vizlib sankey 1
Waterfall Chart 1
Web Connectors 2
web file 1
week 1
weeks 1
wellness 1
what's new 1
Where 2
where by 1
Where clause 2
Where Not Exists 1
while 1
widget 1
widgets 2
Wildcard 1
wildmatch 2
windows server 2
Word 3
Word Table 3
WordCloud 1
words 1
working days 1
worksheets 1
Writeback 1
wrong value 1
XML 1
y axis label 1
year 1
Year Loop in Script Editor Inline Table 1
Year month 1
Year on Year 1
YearQuarter 1
ytd 6
zero 1

New to Qlik Sense

Topics with Label: Distinct

Aggr Count Distinct function

Dúvidas sobre Distinct na expressão

Sum by Order Number with multiple dates

Load only Max Date per Application Number

How to use Count and Distinct function together in...