New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Date format conversion

by on Latest post on by

4 Replies 889 Views

4 Replies

889 Views

converting a text to date and time

by on Latest post on by

2 Replies 1270 Views

2 Replies

1270 Views

Mixed Date Formats in Column

by on Latest post on by

1 Reply 650 Views

1 Reply

650 Views

Change column format from General to Date

by on Latest post on by

14 Replies 5113 Views

14 Replies

5113 Views

Convert text to date.

by on Latest post on by

4 Replies 3963 Views

4 Replies

3963 Views

Date Format

by on Latest post on by

2 Replies 694 Views

2 Replies

694 Views

Subscribe by Topic

"colour" "bar chart" 1
"Data Handling" "Nested Ifs" "Multiple Conditions" 1
"data reduction" "section access" 1
"Função totais" 1
"gamma distribution" "passwords" 1
"Left Join within condition" 1
"Left keep" 1
$field 1
% 1
% of Total 2
' 1
'2-Develop' 1
'aggregate' 1
'comment field' 1
'comment table' 1
'condition' 1
'Filter' 1
'order by' 1
'Qlik Sense' 1
'Qlik' 1
'Sense' 'Install' 'Windows 16' 1
'where' 1
* values 1
** 1
- sign 1
-(aggr( formula 1
...................... 1
.json 2
.NET 2
.net api 1
.NET Core 1
.net framework 1
.net sdk 2
.qvf file 2
.qvf file error 1
.qvf file not opening 2
.qvs 1
.qvs file not working 1
0 values 1
000 1
000 only. 1
100% 2
100% Stacked Bar Chart 3
14days 1
2 Different dates in data model 1
2 dimensions 1
2 nodes 1
2 variables 1
20% 1
2020 June 1
2021 1
3-Tier architecture 1
30 60 90 Day Filter 1
3000 1
3D Scatter plot 3D Surface plot 1
4 weeks in Pivot table 1
400 Bad Request 1
401 Authorization Required 2
403 1
404 1
404 Error 1
4d 1
4dd 1
6 1
<dimension> 1
> 1
@Anil_Babu_Samineni 6
@CELAMBARASAN 3
@Dalton_Ruer 2
@Gysbert_Wassenaar 3
@Henric_Cronström 3
@Jagan 3
@jagmohan 3
@kaushiknsolanki 2
@kiranmanoharrode 1
@MarcoWedel 1
@marcus_sommer 1
@MayilVahanan 5
@mto 2
@Oleg_Troyansky 1
@OmarBenSalem 2
@OmarBenSalem @Dalton_Ruer 1
@PavanNallani 1
@pradnyan 2
@qlik sense 24
@qlikview 6
@rwunderlich 2
@Set Analyis 3
@sunnytalwar 18
@swuehl 5
@Taoufiq_Zarra 2
@tresesco 2
@vamsee 1
@vegar 2
a new field from already calculated fields LOAD 1
AAI 4
abbreviation 1
ABC analysis 2
above 15
above() 6
Above() function 10
above() in bar chart 1
absolute value 2
accent 1
accesos 1
Access 15
Access Control 4
Access Database 3
Access Denied 5
access issue 1
Access not updating 1
access pass 1
access rights 2
access rule 2
Access to a particular group by using binary load in server 1
Access to control centre of Qlik Sense 1
accessibility 1
accessing streams 1
AccessToken 1
accordion 1
account 1
Account Balance 1
account partner activate 1
account termination 1
accounting 2
accumulate 3
accumulate sum 1
accumulated 2
accumulated sum 5
Accumulation 5
accumulative line in combo chart 1
Acess 1
Acessar um dashboard a partir de uma intranet 1
ackumulated sum 1
acsii 1
action 2
action button 4
action in qliksense 3
Actions 7
actions and triggers 4
Actions Bookmarks Dates 1
active caption 1
Active Directory 6
Active employees 1
actual currency rate from National Bank 1
Actualizacion 1
Actuals 2
Acumula 1
acumulado 2
acumulados 1
acumulated 1
acumulative 1
AD 1
ad hoc report 1
add 4
Add AVG 1
add column 2
add data 3
add fields 1
Add fields dynamically to expression 2
add limit 1
Add new rows to an existing column 1
add rows 1
add user to app (Qlik Sense Server) 1
add zeros 1
addieren 1
addifset 1
Adding dynamic values 1
Addmonths 2
addyears 3
ADFS 2
adhoc 1
Adhoc & Dynamic Reporting in QlikSense 2
Adjust 1
Adjusting 2
Admin 8
admin roles 1
admin termination 1
Administration 6
Adopt the specific values with function: peek() 1
Advance Analytics 1
Advance scripting 1
Advanced Aggr 1
Advanced Analytics Toolbox 3
Advanced Authoring 1
advanced filtering 1
advanced maps 1
Advanced qlik 1
advanced text object 1
Advanced visualization 1
Advanced-analytics-toolbox 1
age 5
Age Bucket 2
age calculation 1
Age Count Countif 1
age formula 1
Age Grouping 2
age range 1
agg 1
Aggr () in KPI 1
aggr avg sankey 1
Aggr concat with count 1
Aggr Count 1
aggr function 6
Aggr GroupBY Year Help QlikSence 2
Aggr GroupBY Year Help QlikSense 1
Aggr Help GroupBy Year QlikSence 1
aggr if 4
AGGR in set analysis 15
Aggr Only 1
Aggr or Set Analysis 10
Aggr QlikSence Example 3
Aggr QlikSence Help GroupBy Year 1
Aggr Sum 12
AGGR() 16
AGGR() ordering 2
Aggr. Function 8
aggregate 18
Aggregate and Average 8
aggregate areas 1
aggregate count 1
aggregate sum 3
Aggregate value not showing in the sheet 1
aggregated 1
aggregated data 1
aggregated sum in matching fields 2
aggregating data 3
aggregating grouped dimensions 1
aggregating previous months 1
aggregation 22
aggregation function 3
Aggregation in script 4
aggregation in set analysis 1
aggregation with if 1
aggrigation 1
Aging 1
Agregate 1
agrupar 2
aider 1
aircraft 1
airline 1
alb 1
alert 3
alerts 1
Alias 2
alignment 2
all 1
all records 1
allocation 1
allocations 1
Alphabetic order 1
Alphanumeric Sorting in Qlik Sense 1
Alt 2
alternate 1
Alternate Dimensions 1
Alternate extension 1
alternate state 3
Alternate State complexity 1
Alternate State count filtered 1
alternate state with If condition 1
Alternate States 21
Alternate states dimension IF alternate states 2
alternative 1
Alternative dimension 2
alternative measure 1
Alternative Measures 1
Alternative state 1
alternativedimension 1
always one selected 2
always one selected value 1
Always One Selection 1
Amazon 1
Amazon Redshift 1
amazon S3 2
Amazon S3 Connector 2
Amazon Web Service (AWS) 2
amortization 1
AMP 1
an error has occurred 1
an error has ocurred 1
An error occurred 2
Analisis de conjunto 1
Analyses 1
Analysis 11
Analysis Services 2
Analyst Exam 1
Analytics 4
analyzer 6
analyzer allocations 1
Analyzer Capacity 1
Analyzer role 2
and 7
and automatically upload excel file 1
AND logic 2
and MEDIAN 1
and operator 1
and or operator 2
AND-mode 1
AND_Operation within column 1
Android 2
angular 4
AngularJS 1
anidar 1
anil babu 3
animated graph 1
Animator 1
anit join 1
annotations 1
annual 1
ANO-SEMESTRE 1
Anonymous users 1
another column comparison 1
any tool to convert Qlikview app to Qlik sense 1
AnyChart 6
AnyChart extension 2
AnyGantt 5
AnyGantt Extension 4
ao usar filtro não localiza dados 1
Apache 2
API GooglE Maps 1
API's 2
apiangular 2
APIs 4
app 7
App contents 1
APP Custom Properties 1
App Development 23
APP ID 1
App Integration API 1
app level management 1
app load issue due qlik sense version 1
App Name or QVF Name and QVD Name details 1
app navigation 2
app objects 1
App Overview Improvement 1
app owner 1
app performance 1
app preload 1
app published date 1
app publishing 1
app reload 1
app security 1
App Size 2
App theme 1
appear 2
Appearance 1
append 5
append string depending on lenght 1
Appending a column 1
Appending Data Monthwise from extractor 1
Appending Extracted data for the month 1
appending qvd for the month 1
appid 1
application 9
Application Automation 3
Application Development 3
Application import error 2
application issues 1
application save failed 1
applicationmaintenance 1
applications 2
Apply 1
apply map 1
apply multiple changes 1
applymap 11
Applymap() 18
ApplyMapp 1
applymapping 1
Appointments 1
approval 1
approve 1
apps 9
appscripts 1
AppyMap 1
April 2019 2
Architecture 1
Archive 2
area 2
area layer 3
Area Map 2
areas 1
arquitetura 1
array 5
array type data load data base 1
arrg 2
arrows 1
Articles 1
Arvore 1
as 1
As of table 1
As Qlik Help 1
AS400 1
ASCII 1
ASCII to char 1
asignar proyecto 1
asof 1
asset 1
Assign Current User Name to Variable 1
Associate 1
associate table 1
Association 7
Association between two tables 1
association reccomendation 1
associations 6
Associative 1
Associative Insight 3
associative model 1
AsStaticHeaderUserViaProxy 1
Atlassian 1
attendance 1
attrition 2
attrition rate 2
audit 1
audit admin 1
auth link 1
Authenication 2
authenticate against qlik sense enterprise 1
Authenticate Qlik Desktop 2
authenticate qliksense desktop 1
authentication 12
authentication in qliksense 1
authorization 4
auto bookmark by sheet 1
auto calendar 3
auto calendar in semester to date 1
auto generate 1
auto generated Script 1
Auto Refresh 4
Auto resize 1
Auto Sum Total functions 1
auto zoom 1
auto-filtration 1
auto-select 1
Autocalander 1
autocalendar 7
autofill 1
autogenerate 3
Automated 1
Automated Data Exploration 1
Automated Mail 1
automatic 2
Automatic Field Filling 1
automatically 1
Automation 4
automise 1
AutoML 1
autonumber 3
autonumber() 2
autosave 1
autozoom 1
Autozooming in Qlik Sense 1
availability 1
Averag of weekdays 2
average 28
Average Calculation 9
average calculations 3
Average Count 3
Average Count Set Modifier 1
Average days 1
average formula 4
Average growth Rate of two measures 1
average line 2
average measure 1
average of quartile 1
Average reference line 2
Average Time Interval Duration 1
Average Trendline 5
averages 2
avg 13
avg daily 1
Avg Function 4
avg with many agg 1
avg() 2
AvgHeadcount 1
avinashelite 1
AvoidOverlapping 1
AWS 5
axis 6
Ayuda 6
Azure 4
Azure Cloud 1
azure devops 1
Año 1
Back button 1
background 5
background color 9
background color in button 1
Background color In pivot table 2
Background color in table 1
background color in tables 1
background colour 2
background expression 3
background image 2
Background Image in landing Page 1
backgroundColor 1
backgroundcolorexpressions 1
BackgroundColourExpression 1
backgroundexpression 1
backup 12
backup and restore 2
Backward Planning 1
balance 2
Balkendiagramm 1
banco de dados 1
Banding 1
Banner in QlikSense Hub 1
bar 9
Bar & Area Chart 10
Bar char 10
Bar Chart 2 dimensions relative percentage stack 2
bar chart comparisons 1
bar chart dimension 1
bar chart expressions 8
Bar chart sort 2
Bar Chart with Month and Year 1
Bar chart with values 10
Bar charts 22
Bar charts expressions 6
bar colours 1
bar graph 9
bar offset 1
barchart 23
Barchart - Rolling 12 months 1
barchartwithGroupedandStack 1
Bargraph 1
barras 1
barsplus 3
Bart chart with a filter of selection 1
BASE 64 1
based on field values 1
baseline 2
basic authentication 1
Basic Guidelines 1
Basic Training 1
Basics 3
basket 1
batch 1
before 3
before() 4
begginer 1
beginner 7
beginner help 4
below 2
below target positive 1
Best chart 1
Best Practice 1
Best Practices 12
between 4
Between Qlik Sense 1
between two dates 1
BI 3
Big Data 4
big query 1
Big Screen Dashboard auto refresh 1
bigquery 1
binary 1
binary chart 1
Binary Load 8
binary signal 1
bins 1
biweeklydate as dimension 1
bla bla bla 1
blank 6
blank fields 1
Blanks 1
blocks 1
blog 1
body parameters 1
bold 3
BOM 2
bookmark 13
Bookmark creation 1
bookmark Issue 1
Bookmark object 3
bookmark security Rule 1
Bookmark Set Expression 1
Bookmark sharing 1
Bookmark Trigger 2
Bookmarks 15
Bootstrap 1
borders 2
BOT 2
bottom 1
Bottom 10 values 1
botão 1
box 1
box filter YTD 1
Box Plot 6
boxplot 3
brackets 1
branch 2
branding 1
breadcrumb 1
break 1
Break line 1
Break line chart 1
BreakEven 1
britt 1
browser 1
Brushing 1
BSEG 1
btp 1
bubble 2
Bubble Dimension restrict 1
bubble layer 1
bubble size 1
Bucket 1
Bucketing 3
buckets 6
Budgeting 1
bug 13
Bugs 6
Bugs & Errors 28
bulle 1
Bullet Chart 2
Bullseye Chart 1
business 2
Business Analyst 5
business days 1
Business Intelligence 5
business logic 1
business trial 1
but the User dont see anything 1
but user able to access other reports(QMC) 1
Butterfly chart 1
button 15
Button Actions 13
button extension 3
button for navigation 3
Button Navigation 2
Button to select Field 8
Button to switch betweeen languages 1
button. 1
ButtonActions 4
buttons 6
Buttons. 1
by 1
by date 1
by expression 1
by month 1
ByExpression 1
bytes 1
C sharp 1
CA certificates 1
CAC 1
Cache 5
Cache objects 1
cache warmer 1
cache_warmer 2
cached memory 1
calander 1
calculate 3
calculate a measure between two dates 1
Calculate Aggregation 2
Calculate Count of Unique ID with Grouping in Qliksense 1
Calculate dimension 1
Calculate percentage 3
calculate percentage using total in table. 1
calculate total with variables 1
Calculate ytd values 1
calculated column 1
calculated columns 1
Calculated date 3
Calculated Date Dimension 1
Calculated dimension 21
Calculated Dimension Colors 1
calculated dimensions 5
calculated field 21
calculated fields 5
calculating 1
calculating age 1
calculating conditions 1
calculating dates 1
calculating values in script 1
calculation 13
Calculation Condision 2
Calculation Condition 6
calculation of avg by excluding of certain numbers 1
Calculation of Rolling period by 8 weeks to get the sum of appropriate measure 1
Calculation per day 1
calculation support 1
calculation timed out error 1
calculations 12
Calendar Control 2
Calendar Extension 2
Calendar Measures 3
calendar script 2
Calendar table 6
calendar view 1
Calendario 3
calendars 2
Calender 3
Call 1
Call center 2
Cals 1
Campo 1
campos 1
Can I get [Total contract Value] result value below 2 1
Can't open my Qlik Sense Destop 1
cancel request 1
cannot load 1
canonical calendar 3
Canonical Date 4
cantidad 1
capability api 6
capitalize 1
capture 1
capture the last loaded value 1
capture the records that have 2 data loaded with a specific value 1
Car 1
cardinality 2
care 1
Carga com o arquivo atual 1
Carga Fichero 1
Cargar archvo excel 1
carte 1
Cascading 1
case 1
case insensitive 1
Case Sensitive 1
Case Statements 1
case when 3
Cashflows 2
categoria 1
categorical 1
Categorize 3
category 7
Category Categorization Override 1
CEF Error 1
cell 1
cell value 1
cells 1
celula tabela data 1
Central Node 1
certain row no 1
certficate 3
certificate 5
certificate security 1
Certificate Verification 2
certification 9
Chaining 1
challenge 4
change 6
Change color 1
change date 1
change default colors 1
change field name 1
Change Headers 1
Change Name Dimension Maps 1
change selection 1
Change YOY 1
changing chart 1
changing colors dynamically 1
changing title colors 1
char 3
character 1
Character Set 1
characters 1
Charges 1
charset Umlaut display Loading skript UTF-8 1
Chart 3,360
Chart bar 8
Chart Exclusion 1
chart expression 9
chart expressions 18
chart filter 1
chart function 2
chart functions 5
chart interaction 3
Chart label 1
chart legend 1
Chart level grouping 1
Chart Line 3
chart mesaure script 1
Chart Object 12
chart properties 1
Chart reference lines 1
Chart Selection 3
chart selections 1
chart sense color 2
chart should not change values on the selection made on it 1
chart title 1
chart with three columns 1
Charts Select 4
chatbot 2
CHAVE 1
check 3
Checkbox 1
checked 1
checksum 1
chennai 1
child 1
chr(39) 1
chrome 2
circle reference 1
Circular Reference 5
Circular reference error 1
circular_reference 2
Claim Line 1
claims data financial data 1
class 6
class function 1
class() 2
classification 1
Clean 2
clean output 1
Cleansing 1
clear 1
Clear filter 1
clear selection 2
ClearAllTrigger 1
ClearFields 1
Cli 3
click cell 1
client auth link 1
Client Authentication 1
Client authentication link 1
Client Managed 1,318
Climber 3
climber cards 2
Climber Container 1
climber kpi 1
Climber Selection Bar 2
Closing 3
Cloud 11
Cloud Business 6
Cloud Sense 6
Cloud services 2
Cloudera 1
cluster 2
CMD 2
Code 2
code release impact 1
Code Validation 1
coding 1
cohort 1
coldfusion 1
collaboration 1
Collaborative Notes Overview 1
Collapsible Dimension 1
collation 1
collections 1
color area layer 1
Color background in pivot table 5
Color blind 2
color by conditions 3
color by dimension 3
color by dimension and by measure 1
Color by dimension value in qliksense 5
Color by dimension value in qlikview 1
color by expression 12
Color by measures value in qliksense 5
color by trend 1
color change 1
Color coding 6
Color Coding Logic for Pivot table 4
Color condition error 2
color condition on text box 1
Color conditioning 1
color de fondo 1
color dimension 2
color expression 7
color expression for numberintervall 1
Color for measure 2
Color formatting 3
color line chart 1
color line chart by trend 1
Color linked 1
color measure 2
color mix 1
color of labels 1
color schema 1
color text 1
colorchange 1
Colorear número en gráfica 1
COLOREAR POR EXPRESIÓN CUARTIL INFERIOR-SUPERIOR 1
Colorexpressions 1
coloring 3
coloring of total depending on subtotal 1
coloring pivot table 2
ColorMix 5
colormix1 1
colormix2 3
Colors 11
colour 6
COLOUR BAR GRAPH MEASURE 2
colour by expression 4
colour change 3
colour selection 1
colourblind 1
ColourbyExpression 2
ColourByMeasure 2
colours 1
column 22
column dimension 3
column headings 1
column hide 1
Column labels 1
column limitation 1
column name 1
column order 2
column resize 1
column table criteria 1
column table measures 1
Column Total in P&L pivot table 1
column width 1
columns 6
columns change 2
columns dynamically from excel sheets 1
Columns to Rows 1
Coluna 1
coluna dias atrasados 1
combi diagram 1
combination 1
combination chart 1
combine 5
combine dimensions 2
Combine fields 7
combine master item 1
Combine of flags 1
Combine rows 2
combined chart 4
combining 1
combining tables 2
combo 2
Combo chart sorting 1
combo charts 4
combochart 2
Combustible 1
comma 1
comma separated 1
commands execution 1
Communication 1
Community Corner 1
Community Document 2
Community Help 12
community sheets 1
communtiy 1
Como incluir uma imagem no dash usando uma claúsula de condição 1
Comodo 1
Comparation 2
COMPARATIVE 3
comparative analysis 8
comparative field 1
compare 12
Compare date 3
Compare Dates 1
Compare Dates in between in another column 1
compare dimensions between rows 1
Compare Field with other Field in same dimension 3
compare fields script 1
compare numbers 2
compare range with each other 1
Compare rows of same table and Create flag 1
Compare same periods different years 1
compare two columns 2
compare two values 1
Compare Values Qlik Sense Help 3
compare_periods 1
CompareValue Compare SameTable Qlik HelpPlease 3
Comparing Dates 2
Comparing the datas 2
comparison 13
comparison between months 6
Comparison Type 1
comparison via set expression 1
comparison_period 1
compatibility 1
Competitive analysis 1
Compiled Open Source Plugins 1
complete row lines with data 1
complex measure 1
complex OMIT 1
complex pivot 1
complex Reduction 1
composite key 5
composite keys 2
compression 1
Concat 14
Concat on two generic fields 1
Concat value 2
Concat() 2
concatenante 1
concatenar columnas osticket concat columns NA 1
concatenat 1
concatenate 17
Concatenate 2 Fact tables 1
Concatenate based on list 1
concatenate expressions 2
Concatenate fields 3
Concatenate more rows to one row 2
Concatenate x Lef Join 1
concatenated 1
Concatenating data 4
Concatenating data monthwise 1
concatenation 4
Concescutive 1
condiciones 1
condition 7
condition based count 1
conditional 9
conditional collor 3
conditional color 2
conditional colors 3
Conditional Column 8
conditional count 2
Conditional Date Format 2
conditional dimension 1
conditional display 3
Conditional Display of Measures 5
conditional expression 2
Conditional Expressions 16
conditional filter 1
Conditional format 4
Conditional formatting 12
Conditional formatting in Qliksense 3
conditional group 1
Conditional images 2
conditional load 1
conditional set analysis 1
conditional show 1
conditional split 1
conditional statement 1
conditional sum 2
conditional sum with variables 3
ConditionalExpressions 13
Conditions 12
Conditions matching 2
conector 1
conector web 1
Configuration 36
connect 1
Connect Google Analytics Google Big Query Error assigned catalogs 1
Connecting to DerbyDB 1
Connecting to GCP using Qliksense 1
Connecting to QlikSense via .NET SDK 2
connection 17
connection error 4
Connection issue 2
connection lost 6
Connection Microsoft Access 365 Database 1
connection string 3
Connection to Qlik Sense Engine Failed 1
connections 9
Connectivity 1
Connectivity - Sources or Targets 5
Connector 11
connector error 1
Connector reply error 2
Connectors 7
consolidate 2
Constant 2
constraint 1
Consumer 1
Consumer Node 1
Contador de datos sin repetición 1
container 12
containers 4
contar 1
Contar un solo criterio 1
contcat 1
content 2
content admin 1
content library 4
context 2
context menu 1
continuopus classroom 1
continuous 2
Continuous Classroom 1
continuous data 1
continuous scale 3
continuous Service 1
Continuous Value (Data) 1
contraseña 1
contributors 2
Control Chart 2
control dimension values 1
Conversion 6
conversion table 1
convert 7
convert monthly to daily 1
convert numbers to words 1
convert problem 1
convert qlikview to qlik sense 1
convert sql to qlik code 1
convert string to number 1
convert tiff files 1
converter 3
converttolocaltime 2
Coomand to execute QS 1
coordinates 4
copy 3
Copy Value 1
Copying data 1
cores 2
correl 1
Correlation 2
Correlations 1
Corrupt 1
corrupted data 1
cors 2
CORS Vulnerability 1
Cost 2
CouchBase 1
Count 17
count according to rank 1
Count Aggr If 10
Count based on another counted field 5
Count Blank 1
Count clarification 1
count count it 1
count days between two dates 1
count distinct 3
Count Distinct by Multiple Criteria with Max Date 1
Count Distinct if 2
count duplicate 1
Count formula 1
Count if 12
Count if condition 7
count if date filter 1
count if null 1
COUNT if two conditions 12
count number of date 1
count of 4 consecutive date with respect to id 1
count of count 1
Count of distinct with set analysis 1
count of rows 1
COUNT Parameters 10
Count Rank 1
Count Rank QlikSence Help 1
Count record by data 1
count rolling 12 months 1
count rows 1
count session active 1
Count sheets 1
count the number of projects 1
Count top 10 from table 1
Count unique 1
COUNT UNIQUE OCCURENCE 6
count with condition 1
Count with If condition 2
count words 2
count() 6
count(distinct ) 1
countDistinct 1
counter 3
Counter Field 1
Countif 4
Countifs 1
counting 3
counting words 1
Countries 2
Country based on city 1
counts 3
COVID-19 2
cpu 2
Crash 2
create 1
CREATE "CALENDAR" 1
Create a intervall from single column 1
Create column based on measure 1
Create connection Script editor 1
create drill down with Master Items on Dimension 1
create flag load editor 1
create flags (dynamically) depending on year 1
Create from one data-column two columns 1
Create in Scriptarea the key figures (as one expression) 1
create new app 2
create new field 2
Create one table from 3 columns 1
create separate block each in block chart. 1
Create Tables Automatically 1
creating a table from one table 1
creating columns 1
creating dates 1
creating new field 1
Creating of filter with: if then 1
Creating Relations between two tables in a Load Script Editor 1
Creating start and end time from changing dimension 3
creation of backward data field 1
Credentials 1
criteria 2
crm 1
Cross App data selection 1
cross filter 1
cross hub access 1
Cross Tab 3
Cross Table 12
cross table in qlik sense 2
cross tables 1
Crosstab 1
crosstable 22
Crosstable multiple rows 1
Crosstable or another way of tabletransforming 1
CrossTable with multiple columns 3
Crosstable(transforming of table) 2
CSR 1
css 18
cst 1
CSV 13
CSV file upload to QLIK Sense Cloud 2
CSV to QVD without Qlik 1
cte 1
Cube 2
Cummulative 8
cummulative sum 3
cumul 1
Cumul Value while Selection 1
Cumul Value within Pivot plus Dimension (horizontal) 1
Cumul Value within stacked barchart 1
cumulative 12
cumulative % 2
Cumulative calculation using range sum function 3
cumulative chart 1
cumulative count 3
Cumulative count with 2 dimensions in a bar chart 1
Cumulative counts for multiple dimensions 1
Cumulative Returns 1
cumulative sum 3
cumulative sum in chart 2
Cumulative sum in cross table 1
Cumulative sum in straight table 1
Cumulative summation by date 4
Cumulative summation by dimensions 4
Cumulative total 2
cumulativesum in Qliksense 1
cumulul value in depence on moths 1
Currency 1
currency exchange 1
Currency Rate 2
current 2
current cell value 2
current month 3
current month like period 1
Current Selection 2
current selections bar 1
Current Week 1
Current Year 4
Current year vs last year 1
curva abc 1
custom 7
custom chart 2
custom classification 1
Custom Color 3
Custom Component 3
custom date filter 2
Custom Dimension 1
Custom Extension 2
custom field 3
custom limitation 1
custom measure visibility 1
custom measures 2
Custom Message 1
custom objects 3
custom pie chart 1
Custom Production Hours 1
custom properties 5
custom property 1
custom region 1
custom reports 2
custom sort 4
Custom Sort Order in QlikSense Treemap 1
custom sorting 2
custom theme 3
Custom Themes 2
custom tooltips 1
Custom UI 1
custom variable 1
custom week 1
Custom year 1
CustomConnect 1
customer 1
Customer Value 1
customers 1
Customers bought 1
Customization 7
Customize 3
Customize color 1
Customize my Home 1
customized calendar 2
Customized Filters 1
customized log files 1
Customized measures 1
customized tooltip 1
CustomProperties 2
customreport 1
cut 1
cut off 1
CVS 1
cyclic dimension 1
código 1
d3 1
D3 Extension 2
d3.JS 3
Daily 1
daniel coullet 1
Dashboard 23
dashboard bundle 7
Dashboard Extension Bundle 5
dashboard issues 4
dashboard txt file 1
dashboards 2
data affected in one filter only. 1
data aggregation 1
Data Analytics 12
Data Architect 8
Data Architecture certification 1
Data cleaning 2
data cleansing 1
Data Connection 14
data connections 8
Data Connections QMC 1
data connectivity issue 1
data connector 3
data connectors 1
Data Consistency 2
data converting 1
data cube 1
data currently not existing 1
Data Dictionary 1
Data display for Previous year along with previous year records 1
Data download to excel 1
Data Encryption 1
data exhaustivity 1
Data Export 1
data extraction 1
Data Extraction Issue 1
Data File Name 1
data filtering 2
data format 3
Data From folder 2
data handling 1
Data in Qliksense cloud 1
Data Integration 1
data island 1
data labels 3
Data limitation 1
data load 34
Data Load Editor 3,510
Data Load Error 7
data load fail 1
Data load issue 2
data load problem 1
data load script 2
data loading 4
Data Loading from Source 4
data manager 16
Data Manipulation 4
Data Mapper 1
data masking 1
DATA missing error 2
data mode 1
Data Model 26
Data model Issue 2
Data model viewer 5
data modeling 4
data modell 1
Data Modelling 18
Data Prep 1
Data Preparation 6
Data Presentation 1
Data Quality 2
data range 1
DATA REDUCTION 6
data refresh 1
Data Science 1
data source 2
data sources 1
Data Storage 1
data table 1
data transfer tool 1
data transformation 5
data type 2
data types 3
data upload 1
data validation 2
data visualization 6
Data Warehouse 1
data wrong showing using script editor 1
database 10
database connection settings 1
database connnection 1
database dynamically 1
Database Error 2
Database Query 2
Database Update 1
Dataconnections 2
datafiles 1
Dataflow 1
dataload 7
dataloadeditor 3
Datamanager 3
Datamodel 4
datamodel logic 2
datamodeling 1
datamodelling 1
datapoint 2
datapoint and datalabels 1
Datapoints 1
datarestriction 1
DataSet 4
datatransfer 1
datatype 1
datawarehouse 1
DataWarehousing 2
Date 3
Date & Time 21
Date Bucket 4
date conversion 2
date convert 1
Date converting 6
date data 2
date data exhaustivity 1
date difference 2
date dimension 1
Date Dimensions 6
Date Expression 18
date field 2
Date filter 14
Date Filter selection 5
date format 16
date format not respected 1
Date format wrong. 1
date formatting 4
Date formula 2
Date Functions 18
date groups 1
Date Help QlikSence TimeInterval 1
Date in dimension for Line chart 1
date picker 20
Date Picker Extension 9
Date Picker Extension not recognize Field 2
Date Picker. 4
Date Range 32
date range picker 3
Date range picker extension 4
date range selector 1
Date ranges 6
Date set 3
date settings 1
Date time 2
Date Time interval 1
date time timestamp 2
DATE VALUE 18
Date value to levels 1
Date Variable 2
Date WhereClause 1
date(0) 1
DATE_IN and DATE_OUT in Master Calender 3
datefield 1
Datefield not recognized as Date 1
DateFilter 2
DateFormat 5
DateFormatting 1
DateMonth 1
dateperiod 1
datepicker 6
daterange 2
Daterangepicker 3
dates between 6
dates comparison 2
Dates differenece in days 1
Dates Help 11
dates period 1
Dates Set Analysis 7
Dates Transformation with different formats to single format 1
datesinperiod 1
datestamp 1
datetime 2
datetime stamp transformation 1
DateTimeformat 2
datevariable 1
datewithinadate 1
Datum 3
DAX 1
Dax Query 1
day 3
day count 1
day wise data 1
day(today()) 1
DayName 1
dayofweek 1
days 3
Days of current month 1
db 1
DB2 2
DCom server process 1
de 1
de couple 1
deadline 1
Deadlines 1
Deall 2
debug mode 1
debugging 1
decimal 2
decimals 3
declare 2
default 4
default bookmark 2
default filter 2
Default Filters 1
default search mode 1
default selection 4
Default selection :: filter 1
Default Settings 2
default sheet 1
default value 2
default values 2
default view 2
defaultbookmark 1
define dimensions 1
define measure 1
defining geography 1
Defining Variable DataLoadEditor 1
definition 1
DEL files in Qliksense 1
delete 3
delete account 1
delete row 1
deleted 1
Deleting QVDs 1
Deleting values 1
delimiter 4
Delimiter Split and matching 1
Delimiters 1
delivery on time 1
delta 1
deltaload 2
demension limit 1
demo 3
demo trial 1
demos 2
demos for both qlikview and qlik sense 1
Denominator 2
density plot 1
Dependencies 1
Dependency Explorer 1
deploy apps via api 1
Deployment 4
depreciation 1
derive 2
Derived 1
derrive 1
descending 1
description 1
descriptive 1
design 12
Designer 3
Desktop 12
desktop authentication offline corporate internet filtered blocked 1
desktop client 4
Desktop Download 1
desvest 1
detach object 1
Detailed Drill Down 1
Details 2
Dev Hub 8
deve 1
Developer 9
Developer license 1
Developers 3,806
Development 16
devhub 1
deviation 1
devtools 1
diagram 7
Diagramm 2
Dialog 1
Diarias 1
diff% 1
differance 1
difference 1
Difference Between Dates 1
Difference between two dates 1
difference between View and Sense 1
Difference in Week 1
different 2
Different dates 1
different measures 1
differential load 1
Dimensiom 4
dimension 3,448
Dimension as expression 18
Dimension axes 2
dimension counting 1
dimension expression 1
dimension Filter 1
Dimension grouping based on another dimension 3
dimension ignore filters 1
dimension label 3
Dimension labels 6
dimension level 1
dimension limit 3
dimension limits 2
dimension limmits 1
Dimension of stacked & grouped bar chart 2
dimensional calculation 1
Dimensional DB 1
dimensionality 1
Dimensiones 10
DimensionLimit 1
Dimensions as Measures 1
Dimensions grouping 2
dimensions in formula 1
dimensions in pivot 1
dimensons 1
Dimensão 1
Dimensões de uma imagem para não ficar distorcida no Qlik 1
dimesions 1
Dimesnion % Calculation 1
Direct Discovery 1
Direct Query 3
directory 1
DirList 1
disable chart interaction 1
disable selection 2
disable selection on filter 1
disable standard mode 1
disaggregate 1
disaster recovery 1
discrete points 1
discrete values at all levels 1
Disctinct 2
discussion forum 1
display 4
display common items between two displayed tables 1
display if blank 1
Display label 1
Display Rows 1
Display Table 1
display tiff files 1
Display website dynamically 1
disregard filter Date 1
dissapear 1
distance 1
Distinct 25
distinct count 2
Distinct field values 1
Distinct List 1
distinct sum 2
Distinct values 5
distribute volumes 1
distribution 2
distribution curve 1
distribution plot 7
Distribution Task 1
divide 4
Divide with same column 1
division 3
Division by Variable 1
DM 1
DNS 1
do 1
do while 3
Do While Loop 2
Do While loops 1
Doc 1
DocAnalyzer 1
Document Analyser 2
Document analyzer 3
document analyzer connection error 1
Document Chain 1
Document Chain in Qlik sense 1
document chaining 2
document chaining using Field value in Qlik sense 1
Document Information 1
Documentation 4
Documents 1
Dollar expansion 5
Dollar Sign 4
dollar sign expansion 1
Dollar sign expansion with variable with & operator 1
Dollarexpression 1
domain name 3
Dont join multiple tables 1
dont work visualization 1
donut chart 2
dosave 1
dot 1
dotnet 2
dots 1
double counting 1
Double Dimension 1
double match 1
Double Quotes 1
double values 1
down 1
downlaod 1
Download 8
drill down 12
drill down charts 4
drill down dimension 1
drill down master 2
Drill Through 2
Drill-Down 14
Drill-down report 1
Drilldown 6
drilldowndimension 2
drop down 1
drop down select 1
drop field from table 1
Drop fields 1
drop table 1
drop-down 1
drop-down list 1
dropbox 1
dropdown list 1
dropdowns 1
dst 1
dual 8
dual data type 3
Dual date 1
dual function 4
Dual Set Expressions 2
Dual Use 2
Dual() field 1
duplicate 5
duplicate column names 1
Duplicate data 3
duplicate entry 1
duplicate fields 2
duplicate records 2
Duplicate Rows 8
Duplicate SAMAccountName Network login account 1
Duplicate sheet private wdc 1
duplicate values 2
Duplicate values in pivot dimension 1
duplicate values in straight table 1
DuplicateApp 1
DuplicateID 2
duplicates 6
duration 1
Duties 1
dynamic 18
Dynamic Assignment 3
dynamic bookmarking by sheet 1
Dynamic Calculated Measure 1
Dynamic Charts 4
dynamic data load 1
dynamic date expression 1
dynamic dimension 2
dynamic dimension as variable 2
Dynamic Dimension labels in Title 1
dynamic field name 2
Dynamic filter 3
DYNAMIC FORMULE 1
dynamic join 1
Dynamic KPI 1
dynamic label 2
dynamic labels 1
Dynamic legend 1
dynamic measures 3
dynamic path 1
dynamic report 1
dynamic select 1
Dynamic selections 3
dynamic text 2
dynamic title 1
dynamic update 1
dynamic URL 1
Dynamic value 2
Dynamic Value List 1
dynamic variable 2
Dynamic views 1
dynamic way of replacing 1
DynamicColumns 1
Dynamics 365 1
Dúvida 1
E() 1
each 1
easy to understand 1
Ebiexperts 1
EC2 1
ecuation 1
edit 2
edit data 1
edit email 1
Edit Name of Downloaded Data File 1
edit variable 1
Editing an app 1
editor 3
EDX tasks 1
efficiency 1
else 1
Else Max Date 1
email 7
email alert 7
email hyperlink 1
Email Notification 2
Email Server 2
Embed 5
Embed button to web page 1
embed iframe 1
Embed QlikSense Sheets 3
Embed Sheet 7
Embedded 3
embedding 4
empleados 1
employee status 1
employees 1
Employment opportunity 1
empty data 3
empty values 1
enable 1
enable conditionals 1
enable-non-published-sharing 1
Encode 1
Encounters 1
encryption 2
end date 3
end of file 1
end time 1
enddate 1
Engine 5
engine api 4
Engine is not alive 1
Engine Services 1
EngineAPI 1
Enhancements 1
Enigma 3
enigma.js 3
Enter 1
enterprise 10
enterprise version 3
Entitlements & Permissions 2
Entwicklungsumgebung (wo am besten entwickelt werden muss) 1
Environment 1
equal 1
ErikWetterberg 1
error 29
error 1603 1
error 400 1
Error 500 1
error bars 1
error code 9010 1
error handling 1
error log 1
Error Message 5
Error Messages 3
Error on the hub area 1
Error ORA-01456 Qlik Sense 1
ErrorCode: 4294967192 1
Errorhandling 1
errors 1
Errors - Unexpected Behavior 11
es6 1
Español 2
Esri 1
estado 1
estados alterno 1
etc. into white 1
etiquette 1
ETL 6
Event 2
Events 4
Everyone 1
evolution 1
exact 1
exact match 1
exact string position 1
exam 2
example 1
Example AAI QVF FIles 3
Examples 1
excel 29
Excel data 19
Excel data sets to Qlik 5
excel date format 1
excel export 1
Excel export wrong data 1
Excel Exports 10
excel file 2
Excel import hard disk local file 1
Excel load to Qlikview 1
excel macro 1
Excel pivot data into qlikview 1
Excel Pivot table 2
excel sheets 1
Excel via ODBC 4
excel worksheets 2
except 1
exchange Rate 1
exclude 10
exclude data 4
exclude data in column 1
Exclude dimension selection in filter pane 1
exclude legend 1
exclude value 1
exclude values 2
exclude values in column 1
excluded 1
Excluded Values 2
ExcludedValues 1
excluding 1
Excluding Selections 1
exclue 1
exclusion 3
execute 1
Execute Command 1
Execute Command in Script 2
execution 2
execution time 1
Exhaustive Dates 1
exist 1
Exists 6
Exists() 3
Exluding Entrie patterns 1
Expand 1
expand only left rows 1
Expandissue 1
expansion 1
explaining techical terms 1
Export 17
Export as unicode txt format 1
Export ContextMenu 1
EXPORT CSV 5
export data 8
Export data to excel from qliksense 1
Export data to google spread sheet from CSV file in qlik sense 1
export excel 2
export expression 1
export image 2
export powerpoint ppt 2
Export Script 1
export sheet 2
export to CSV variable automatically export 1
export to excel 6
export to image 1
export to pdf 3
Exportação de dashboards para PDFs 1
exportData 1
ExportDataFileName 1
Exporting data 8
expresion 1
expresiones 1
expresión 1
expression 6,201
Expression builder 13
expression by color 1
expression editor 4
Expression Error 16
expression for reference line 1
expression issue 2
expression to total column 1
Expression Total 2
Expression value selection in to dimension 2
expressions straight table 2
extended sheet 1
extending rows in Qliksense 1
extension - IE issue 1
Extension Development 7
Extension Error 1
Extension Object 1
Extension Objects 10
Extensions 18
extensión 1
External 2
external data 1
extra data point 1
Extract 6
Extract Date from String 1
Fact 1
Fact tables 3
Fact Type 1
facts 1
fail opening hub message first access to sense 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
failed 2
Failed To Invite new members 1
Falha ao abrir hub selecionado 1
family 1
feature 3
Feb 2019 1
Feb 2020 1
February 2019 3
Fecha 2
Fechas 1
Feld duplizieren 1
Fetching Data through rest connector from OrientDB in Qliksense 1
field 13
field addition 2
field as variable 1
Field Load 8
Field name 3
field not found 4
field not found error 4
field over field 1
Field renaming 1
field selection 1
Field Type 3
Field value 6
field values 1
fieldIndex 1
fieldname 1
FieldNumber 1
fields 12
fieldvalue 4
figures 1
filas 1
file 5
file comparison 1
File Detection Trigger 1
File Explorer 1
File format 1
File name 2
File not found error 1
File Parameter 1
file path 2
File upload 1
FileName() 1
files 4
filesize 1
FileSizeMultiplier 1
filesystem 1
Filetime 3
fill 1
fill out the tows 1
filling Data field based on previous row 1
Filling Fields 2
filling missing date 1
filter 2,883
filter actualdate date currentDate setCurrentDate 1
filter by 1
filter by boolean 1
Filter by Data Types 1
FILTER BY DATE 6
Filter by default 1
filter by dimension 2
Filter by multiple values 1
Filter by value 2
filter comma separated 1
Filter condition +Condition Filter - Need help here 4
Filter confirmation 2
Filter DataSource 2
Filter Date 7
Filter Dates 5
filter dependency 1
Filter dimension 1
Filter dimension measure 5
filter expression 2
filter if 1
Filter in data loading 1
filter label 1
filter logic 1
filter measure 1
filter not working 2
Filter Null Values 2
filter on legend 1
Filter only on some data 1
Filter pane with color 1
filter panel 8
Filter panel sort 1
Filter Panes 13
Filter performance 1
filter pivot 3
filter selections 5
filter sum qlik sense 1
filter triggers table creation 1
filter value 3
Filter Visualization 9
filter_tables 1
filtered 1
filtering 9
filtering a bar chart 1
filtering a measure 1
filtering date 1
filtering NULL values 1
filterpane 5
filterpanel 1
filters 24
filters in expressions 1
filters list functions 1
Filterselektion ignorieren 1
filtro 3
FILTRO FECHA SIN VALORES QLIKSENSE 1
filtro na horizontal 1
Filtros 11
Finacial Year 2
Financial functions 1
Financial model 1
financial year 2
Find 3
find and replace 1
Find distinct row values from a number of columns and display the distinct row values as columns. 1
find replace 1
Find the sql or script for the QVD 1
Firebase analytics integration 1
Firewall 1
first 1
First Date 2
First value 3
FirstSortedValue 30
FirstSortedValue in Script 1
FirstSortedValue() 6
FirstValue LastValue 1
Fiscal 1
Fiscal Calendar 1
Fiscal Quaters 1
fiscal year 8
Fiscal Year Calculations 3
fiscalyear string orders 1
fitness 1
Fitting 1
fix 1
Fixar 1
fixed 1
FIXED DIVISION 1
fixed value 2
fixed variables 1
flag 12
flag count 1
FLAG Creation 4
Flag for aggregated values 3
flagging 2
flags 2
Floating 1
floor 1
Floor Map 1
floor plan 1
Flow 2
FlowChart 1
Focus 1
folder 4
folder connection 2
FolderAccess 1
Folders 2
font 3
font color 2
font color script 1
font size 4
font-family 2
fonts 2
Footer 1
for 5
for each 1
for each Next 2
for loop 12
For loop file store 1
for next 3
forEach 1
Forecast 10
forecast data 1
Forecasting 1
Forecasts based on 12 months data 1
Forecasts based on last year's figures for the next coming 3 months 1
Foreign Key 1
format 22
format applied on data cell 1
format date 4
format num 1
format numbers 2
format pattern 1
Format Specification Item 2
format string 1
Formating 10
formato 1
formats 1
formatting 13
formatting date 2
formatting dates 1
formatting issue 2
Formatting Rules 2
Formel 1
formula 23
formula filter 2
formula sum 1
Formula visible 1
Formular sum 2
formulas 3
Formules 5
Fort 1
FQDN 1
fractile 3
frame 1
framework 1
frecuency 1
Free text 1
Freelancer 2
freeze pane 3
from 1
From Folder 1
front end 2
Front End Help 1
front-end 4
frustrated 1
FTP 1
FTP SFTP Connector 3
Fuel 1
full 3
full reload 1
Full row duplicates 1
full screen 2
fullscreen 2
funcion 1
funcionalidades 1
Función 1
function 23
function in element list 1
function in variable 1
function list 2
Functionality 13
FunctionAsVariable 1
functions to a drop down list 1
funnel 5
funnel chart 4
fusion chart 1
future cash flows 1
Future values 1
fuzzy 3
Fuzzy search 1
Fx 1
FY 2
G 1
g3 Broker API 1
Gannt Chart 2
gantt 7
Gantt chart 10
gauge 3
gauge chart 6
Gauge chart (street light) 1
Gauge chart Limits 1
gauge chart percentage 1
Gauge Chart reference line 1
gauge chart- expression doubt-to show latest yearmonth data as default 1
gauges 1
gb 1
General Question 5,929
General QuestionClient ManagedSaaS 1
generate 2
generate date time 1
generate missing data 2
generate values within datafield 1
Generating Months 1
Generation 1
generic 1
Generic calendar 1
generic ldap 1
generic load 3
Geo 2
geo analytics 1
Geo Code 1
geo data 2
Geo location 2
Geo Maps 4
GeoAggrGeometry 2
Geoanalytic 1
GeoAnalytics 12
geoanalytics Qlik sense 1
geocodes 1
GeoCoding Geomapping 1
geodata 1
Geodata layer 1
geodatabases 1
geographic polygons 3
geography 1
GEOJson 1
geolocation 2
geomakepoint 2
GeoMapping 2
geomaps 2
geometry 1
GeoOperations 2
GeoPoint 1
GeoQlik 2
GeoTag 1
GeoTagging 1
get 1
Get Cells from all apps 1
get data from table 1
get field selections 1
Get rid of Duplicates 1
GetCurrentSelections() 2
getfieldselection 2
GetFieldSelections 13
getfiledselection 1
GetObjectDimension() 1
GetObjectField() 1
GetobjectMeasure() 2
GetSelectedCount 4
GetSelectedCount() 1
getselections 2
GetSheets 1
Getting Started 2
Getting Started Webinar 8
Getting the total for 1st and 2nd filter values 1
gigabytes 1
GIS 1
github 1
global filter 1
Global Grouping 1
Global Variables 1
glossary of items 1
GM% filter 1
Gmail 1
GNSS 1
Google 1
google analytics 4
Google Big Query 1
GOOGLE CHRME 1
Google cloud platform 1
Google Drive 1
google drive connector 2
google forms 1
Google road maps in qliksense 1
Google Sheet 1
google sheets 1
google spreadsheets 1
Googleapis 1
Governance 2
governance dashboard 1
gps 1
GPS co-ordinates 1
gradient 3
grafico 5
grafico de barras 4
grafico de torta 1
grand total 2
granularity 2
Graph 28
graphics 2
graphique 2
Graphs 2
greater 2
greater than 5
greater than equal to 1
greater than in measure 2
greater then 1
greater_than 1
greatest 1
greybar 1
grid 3
Grid chart 1
grid height 1
gridlines 1
group 11
group bar chart 1
group by 23
Group by in Load 13
GROUP BY ISSUE 11
Group data 4
group dimensions 2
group nodes 1
Group_Discussions 3
groupby 3
Grouped Bar Chart 6
Grouped data 3
grouping 7
grouping flaw 1
Grouping line chart 1
grouping values 2
groupings 1
Groups 1
growth 2
Growth pivot table 1
growth rate 5
gráfico 3
Gráfico de Barras 1
gráfico de linha 2
guage 1
Guage in Trellis Container 1
GUI 1
guide 2
Gysbert_Wassenaar 2
half hour 1
Hana 1
hardcode expression qliksense KPI 1
hardcoded value KPI expression qliksense 1
Hardware 1
having 1
HC 1
headache 1
Headcount 3
header 6
header authentication 4
Header collumn Pivot 1
headers 1
Headings 2
health 1
Health Care 1
Healthcare 2
heat map 2
Heatmap 8
heatmap chart 1
Heatmap chart - visualization bundle 4
heirarchy 1
help 27
Help ! 11
Help Compare Table SetAnalysis Field 1

New to Qlik Analytics

Topics with Label: Date converting

Date format conversion

converting a text to date and time

Mixed Date Formats in Column

Change column format from General to Date

Convert text to date.

Date Format