Expand
Qlik.com
|
Qlik Help
Community
Ask a Question
All community
This category
This board
Knowledge base
Users
Products
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In / Register
All community
This category
This board
Knowledge base
Users
Products
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Forums
Support
Ideation
Qlik Gallery
Blogs & Events
Learn
Greenway
Opens new window
App Development
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Announcements
Skip the ticket,
Chat
with Qlik Support instead for instant assistance.
Qlik Community
:
Forums
:
Analytics
:
App Development
:
Topics with Label: Hide and show object
Options
Mark all as New
Mark all as Read
Float this item to the top
Subscribe
Bookmark
Subscribe to RSS Feed
Topics with Label: Hide and show object
Showing topics with label
Hide and show object
.
Show all topics
Hide top Qlik Sense Bars Programmatically
by
lylererger
on
2020-04-02
04:11 PM
0
Replies
300
Views
0
Replies
300
Views
Subscribe by Topic
"Aggr"
1
"Clave sintética"
1
"qlik sense"
1
"Sum"
1
$
1
$(vDimSet)
1
$1
1
$field
2
%
2
%Gain
1
''
1
'set analysis'
1
-2) ) &'W'& week(weekstart(TempDate
1
-2))
1
-2)) ) as fweek
1
-sum
1
.NET
1
.net sdk
1
0
2
100% Stacked Bar Chart
1
12 months average
1
2 dimension but display 1 string value in x axis
1
2 fields equates
1
200MB
1
2019
1
2nd row
1
3 months prior
1
3d bar charts
1
401
1
404 Error
1
>Alphanumeric
1
@bill_markham
1
@CELAMBARASAN
2
@Gysbert_Wassenaar
5
@Henric_Cronström
4
@Jagan
1
@Jontydkpi
1
@kaushiknsolanki
1
@Levi_Turner
1
@MarcoWedel
1
@marcus_sommer
2
@maxgro
1
@mto
1
@Nebula
1
@Oleg_Troyansky
1
@qlik sense
8
@rbecher
1
@Rob Wunderlich
1
@rwunderlich
7
@rwunderlich @marcus_sommer @Oleg_Troyansky
1
@Set Analyis
1
@sunny_talwar
11
@sunnytalwar
4
@vamsee
1
@vegar
1
abort
1
aborted
1
above
11
above value
2
above()
6
Above() function
15
above() in bar chart
1
absolute path
1
Access
6
Access Denied
5
access issue
1
access rule
3
AccessToken
1
Account Balance
1
accumulate
3
Accumulate but Different
1
accumulated sum
2
accumulates
1
Accumulation
7
accumulative
1
accumulative line in combo chart
1
action buttion
1
action button
1
Actions
4
actions and triggers
1
Active Directory
3
Actuals
1
acumulado
1
acumulated
1
AD
1
AD Group
1
add
1
add a column
1
add data
2
add fields
1
add rows
1
Adding data from previous column in pivot table
1
Addmonths
1
adhoc
1
adjustment
1
adm2
1
Admin
7
advance authoring
3
Advance scripting
3
advanced
1
Advanced Analytics
3
Advanced Analytics Toolbox
2
Advanced Authoring
1,411
advanced mode
1
Advanced qlik
3
Advanced Search
2
Advanced Section Access
1
advanced set analysis
3
advanced text object
1
Advanced visualization
1
after
1
after()
2
ag-grid
1
age calculation
1
Aggr and Average - Syntax
1
Aggr Count
2
aggr function
6
aggr if
2
AGGR in set analysis
2
Aggr Only
2
Aggr or Set Analysis
13
Aggr Sum
5
AGGR()
1
AGGR() ordering
3
Aggr. Function
7
aggregate
22
Aggregate and Average
2
aggregate sum
2
aggregated data
1
aggregated Dimension
1
aggregated sum in matching fields
2
aggregating data
4
aggregation
14
aggregation function
2
Aggregation in script
2
aggregation in set analysis
2
aggregation scope
1
aggrigation
2
Agile
1
Aging
1
ago
1
Agregate
1
AI
1
alerts
1
algorithms
1
Alias
3
Alias Load
1
align
1
alignment
1
allow non select queries
1
alphabetical
1
alternate dimension
1
Alternate Dimensions
2
alternate measure
3
alternate measures
3
alternate state
4
Alternate State complexity
1
alternate state with If condition
1
Alternate States
32
Alternate states dimension IF alternate states
1
Alternative dimension
1
Alternative Dimension and Measure shows in title
1
Alternative Measures
2
Alternative state
1
Alternative to climber KPI extension
1
Alternator
1
alue selected in X field
1
always one selected
1
always one selected value
1
Always One Selection
2
am pm axis
1
Amazon Redshift
1
Analyses
5
Analysis
7
Analytics
3
and
1
AND logic
2
angular
2
AngularJS
1
anil babu
1
animated graph
1
any
1
AnyChart
6
AnyChart extension
4
AnyGantt
5
AnyGantt Extension
5
AnyStock
1
AnyStock extension
1
Análisis de conjuntos
1
API
15
API autentication
1
APIs
1
app
9
App contents
2
App Design
8
app details header
2
App Development
1
APP ID
1
app in to a new app
1
App info bubble
1
app integration
1
app level access
2
App level footer
1
app load issue due qlik sense version
1
App migration
1
app object
1
App overview
3
app reload
1
App responsiveness
1
App Size
2
app_object
1
AppConnection
1
Appearance
2
appid
1
application
2
Application Development
12
application issues
1
applications
1
applymap
3
Applymap()
15
ApplyMapp
1
AppObject
2
apps
7
AppyMap get the last record
1
april 19
1
April 2019
1
april 2020
6
April 2020 Patch 1
1
Arc Text KPI
1
Architecture
1
area
2
area label
1
area layer
4
Area Map
2
array
1
ArraySize
1
arrg
1
ascending
1
assign
1
assignment
1
Associate
3
Association
2
Association between two tables
1
associations
2
Associative
1
Associative Insight
1
Attachment
1
attrition
1
audit
1
australianmap
1
Authenticate Qlik Desktop
1
authentication
5
authentication in qliksense.
1
authorization
3
auto adjust
1
auto calendar
6
Auto format
1
auto generate
1
auto generated Script
1
auto range
1
autocalendar
6
autocalender
1
AutoGenerate number
1
Automate
1
automated export
1
Automated Mail
1
Automated Testing
1
automatic adjustment
1
automatic script
1
Automatic tasks are not running
2
Automatically saving
1
Automation
8
Automation testing
1
autonumber
2
autonumber numeric keys
2
autonumber()
2
Averag of weekdays
1
average
15
Average Calculation
5
average calculations
1
average formula
2
average measure
1
Average Metric Calcualtion
1
Average reference line
1
averages
1
avg
9
Avg Function
5
avg()
2
Avgerage
1
AWS
2
axis
4
Ayuda
1
Años
1
backend
1
backendApi
1
background
3
background color
3
Background color In pivot table
1
background colour
1
background expression
1
background image
2
backgroundcolorexpressions
1
BackgroundsLayers
4
Backin up Book marks
1
backspace
1
backup
2
Balance sheet
1
balancesheet
1
bar
3
Bar & Area Chart
7
Bar char
1
Bar Chart 2 dimensions relative percentage stack
1
bar chart dimension
1
bar chart expressions
8
Bar chart sort
1
Bar Chart with Month and Year
2
Bar chart with values
4
Bar charts
22
Bar charts expressions
3
bar graph
1
bar labels
2
barchart
14
barchartwithGroupedandStack
1
Base
1
Base Sheet
1
baseball card
1
Based on Quarter Selection
1
Basics
1
batch
1
Beautify Help Sheet
1
before
1
before()
3
bell curve
1
below
2
Best Practices
5
bestpractices
1
between
2
between two dates
3
BEX
1
Big Data
1
Big QVD
1
Big Squid
1
bigquery
1
Bin Variable in chart + Class fuction
1
binary
2
Binary Load
12
bins
1
bins depending on cumulative values
1
Bitrix24
1
blank
2
Blank Chart
1
Block value
1
bold
1
bold text
1
bookmark
9
bookmark marcador
1
Bookmark object
3
Bookmark Set Expression
1
Bookmarks
14
Boolean
1
Bootstrap
1
BOT
2
botones
1
bottom
1
Bottom 10 values
1
Box Plot
2
boxplot
4
bracket
1
brackets
1
Brasil
2
Brazil
2
Break From Filter Selection
1
Break line
1
breakdown
1
bubble
3
Bubble chart
1
bubble layer
3
bubble size
1
bubbles
1
Bucket
2
budget
1
budget vs actual
2
Budgeting
1
buffer
2
buffer load
1
Bugs
3
Bugs & Errors
4
Bullet Chart
2
Bullseye Chart
1
Bundle
4
burn up chart
1
business
1
Business Intelligence
6
business logic
1
button
9
Button Actions
5
button for navigation
2
Button Navigation
2
button object
1
Button to select Cases
1
Button to select Field
2
buttons
5
Buzzy996
1
C-Sharp
1
Cache
1
calcul of dimension
1
calculate
1
calculate 12 month average in pivot table
1
Calculate Aggregation
1
Calculate Count of Unique ID with Grouping in Qliksense
1
Calculate delta
1
Calculate dimension
2
calculate inventory with movements
1
Calculate percentage
6
Calculate Tax
1
Calculate the percentage with different groups
1
Calculate YTD values and Life to Date value based on Year
1
calculated column
4
Calculated date
3
Calculated Date Dimension
1
Calculated dimension
13
calculated dimensions
8
Calculated expression
1
calculated field
14
calculation
9
calculation by category and total amount
1
Calculation Condition
5
Calculation of Rolling period by 8 weeks to get the sum of appropriate measure
1
calculations
2
calculo
1
calendar
18
Calendar Control
1
Calendar Measures
3
calendar script
3
Calendar table
1
calendar variables
1
calendars
2
Calender
1
Call
1
Call Procedure
1
canada
1
cancel request
1
Canonical Date
2
CARGA
1
cartesian
2
case
1
case when
1
cashflow
1
Catalog
1
categorization
1
cell
1
cell format
2
cells
1
center
1
certification
1
change
4
Change in Sales
1
change type scrolling
1
changes
1
Character Set
1
Chart
422
Chart bar
5
chart expression
4
chart expressions
4
chart function
2
chart functions
1
chart interaction
1
Chart label
3
chart layer
1
Chart line accumulated by year aggr
1
Chart Object
4
Chart width
1
chartfunction
1
charts
11
Charts Select
1
chatbot
1
Check for QVD file
1
Checkbox
3
chennai
1
child
1
Chile
1
chinese
1
ChiSquare Chi2
1
chr(10)
1
chr(13)
1
chrome
3
ChunkLoadError
1
circular
2
circular loop
1
Circular Reference
6
Circular reference error
1
circular_reference
3
City
1
Class Changing
1
class definition with percentages
1
class()
2
classification
1
Classify data based on a condition
1
Cleansing
1
Cleanup
1
ClearAllTrigger
1
ClearFields
2
ClearSelection
2
Clickjacking vulnerabilities
1
Client Managed
615
climber bar selection
1
Climber Container
1
Climber Selection Bar
2
CLOB
1
closest geo point
1
closest_date
1
cloud
2
Cloud Business
1
cloud deployments
1
Cloud Sense
1
COALESCE
1
Code
3
coding
1
Cognos cube
1
cohort
1
col_1
1
Collaborate
1
Color background in pivot table
1
color background pivot nested dimensions
1
Color by area
1
color by conditions
1
color by dimension
1
Color by dimension value in qliksense
1
color by expression
7
Color by measures value in qliksense
2
Color coding
1
Color condition error
1
Color conditioning
1
color expression
4
Color for measure
2
color palette
1
Color scale
1
color sheme
1
Colorexpressions
1
coloring
1
coloring background kpi
1
colormix2
1
Colors
9
colour
2
colour by expression
4
ColourbyExpression
1
ColourByMeasure
1
column
7
column dimension
2
Column Set analysis
1
column sum dimension
1
column total
1
column update base of another column
1
column width
1
column-size
1
columnno()
2
columns
5
columns Filter
1
Columns to Rows
1
columns_into_rows
1
combination
1
combine
4
Combine rows
2
combined dimension
1
combo
1
Combo chart sorting
1
combochart
1
command line
1
comments
1
common date field
1
community
1
Community Help
4
comparative analysis
2
Comparativo
1
compare
5
Compare date
3
Compare Dates in between in another column
1
Compare Field with other Field in same dimension
1
Compare rows of same table and Create flag
1
compare two values
1
Compare updated data in a field
1
Compare years exclude totals percentage table
1
comparison
5
comparison between months
1
comparison via set expression
1
complement
1
complex measure
3
composite key
1
composite keys
1
Compute
1
Concat
13
Concat on two generic fields
1
Concat()
6
concatenate
10
Concatenate fields
1
Concatenate sort bug
1
concatenated
1
concatenation
2
concatenation of variables
1
condición
1
condition
4
Condition Minus Greater
1
conditional
3
conditional colors
1
Conditional Column
2
conditional dimension
3
conditional dimensions
1
conditional display
4
Conditional Display of Measures
1
conditional expression
2
Conditional Expressions
5
conditional filter
1
Conditional format
3
Conditional formatting
2
conditional grouping
1
conditional load
2
conditional show
2
Conditional statements
2
conditional sum
3
conditional sum with variables
1
ConditionalExpressions
3
conditionally sum dimensions
1
conditioning
1
Conditions
9
Conditions matching
2
condtional
1
config current selection bar
1
Configuration
4
Confused
1
Connection Parameters
1
connection string
3
connections
1
Connectivity
1
Connectivity - Sources or Targets
1
Connector
2
Connectors
4
CONSISTENT
1
console
1
constants
1
consumption
1
container
12
containers
1
content library
4
Contextual help in QlikSense
1
continious value
1
continuous
3
contracts
1
Control Chart
3
Control Charts
1
Conversion
2
convert fields to dimensions
1
convert measures to dimensions
1
convert SQL to LOAD
2
coordinates
2
Copying data
1
cores
1
correl
1
Correlation
2
correlation coefficient
1
corrupted
1
Coung with If
1
Count Aggr If
1
count before
1
Count Blank and show in KPI
2
Count Days
1
count distinct
4
Count if
9
Count if condition
2
COUNT if two conditions
2
count most recent
1
Count of month with corresponding to year
1
COUNT Parameters
5
count total
1
Count with If condition
1
count with multiple criteria
1
count()
1
counter
2
Counter Field
1
Counties
1
Countif
2
counting
1
Country Code
2
County
1
County Area
1
cpu
1
Crash
5
create
1
Create unequal bucket sizes on dimension
1
created
1
CreateSearchIndexOnReload
1
Creating Analytics
4
Creating Timeline
1
Creation of Timeline
1
creativity
1
criteria
2
cross-app
1
crosstable
9
CrossTable format in qlikview
1
Crosstable multiple rows
1
CrossTable with multiple columns
1
Crosstable(transforming of table)
1
crostable
1
crunch bot
1
css
12
css button
1
CSS. THEME. RADAR CHART
1
CSV
7
csv file
1
CSV_source
1
cummulative sum
1
Cumul Value while Selection
1
cumulation
1
cumulative
12
cumulative %
1
cumulative bins
1
Cumulative calculation using range sum function
1
cumulative chart
2
cumulative count
1
Cumulative logic for two expression in Chart
1
Cumulative Market Share
1
Cumulative Market Share Growth
1
Cumulative Principle Amount Between 2 periods similar to excel CUMPRINC ()
1
cumulative sum
7
cumulative sum in chart
1
Cumulative sum in cross table
1
Cumulative sum in straight table
4
Cumulative summation by date
2
Cumulative summation by dimensions
2
Cumulative total
2
Currencies
1
Currency
4
currency exchange
2
Current & Previous Week Calculations in Qliksense Table
1
current month
1
current month vs previous month
1
Current qtr and previous qtr comparison based on qtr selection in pivot table
1
Current Selection
2
Current Selection bar
1
Current Year
1
currentselection
1
cursor
1
custo
1
custom
1
custom area
1
Custom association
2
custom background
1
Custom Extension
1
custom field
2
Custom filter
1
custom map
3
custom markers
1
custom measures
1
Custom Message
1
custom objects
1
custom properties
1
custom theme
1
Custom Themes
6
custom tool tip
1
custom tooltips
2
Custom visualization
1
customers
1
customiseabletable
1
Customization
1
Customize
1
Customize Labels and Colours For Drill-Down Dimension
1
cycle dimension
2
cycle group
1
D3 Extension
1
D3 Sunburst
1
DADOS
1
Dashboard
12
dashboard bundle
5
Dashboard Extension Bundle
1
dashboard filter
1
data
13
Data Analytics
10
Data Architect
3
Data cleaning
1
data cleansing
1
Data Connection
5
data connector
6
Data Encryption
1
Data Encryption in November 2019 Qlik Sense Version
1
Data Extraction Issue
1
data from several fields
1
data handling
1
data labels
1
Data Lake
1
data load
7
Data Load Editor
1
Data Load Error
2
data load fail
2
Data load issue
1
data load problem
2
data load script
3
Data Load Wizard
1
data loader
2
Data Loading from Source
1
data manager
10
Data Manipulation
3
data mapping
2
Data matching
1
Data Model
25
Data model Issue
2
Data model viewer
1
data modeling
6
Data Modelling
17
data point
1
Data Prep
1
Data Presentation
3
Data Quality
3
DATA REDUCTION
3
data refresh
1
data search
1
data security
1
data transformation
1
data types
2
data value on bar chart
1
data visualization
5
Database Error
1
datached calendar
1
dataload
1
dataloadeditor
4
Datamanager
1
DataMarket
1
Datamodel
6
datamodeling
3
dataquality
1
Datasource
1
datatype
1
Date
1
Date & Time
16
Date Bucket
2
date column
1
date comparison
2
date condition
1
date conversion
1
Date converting
1
date convertion
1
date created
1
date dimension
2
Date Dimensions
1
Date Expression
10
date fields
1
Date filter
1
Date Filter selection
4
date format
6
Date format wrong.
1
date formatting
2
Date formula
1
Date from filename
1
Date Functions
5
Date interpretation
2
date interval
1
Date Links
1
date logic
1
Date Order
1
date picker
5
Date Picker Extension
1
Date Picker.
1
Date Range
12
date range picker
2
Date range picker extension
3
Date ranges
1
date selected
1
Date selection
1
Date Slider
1
Date time
3
Date Time interval
1
DATE VALUE
15
Date Variable
4
date.
1
DateFormat
1
DateHashTag
1
datePoundSign
1
dates
20
dates between
4
dates comparison
3
Dates Help
3
dates not working
1
dates period
1
Dates Set Analysis
1
DateTime handling
1
day
2
day count
1
DaylightSaving
1
days
4
DB2
1
DC
1
deafult date format
1
debug mode
2
decimal
1
decimals
2
declare
2
deduplication
1
default
4
Default app font
1
default bookmark
1
default filter
7
default formatting
1
default script
1
Default Security Rules
1
default selection
2
default state inherit
2
default value
2
default values
1
defaults
2
define
1
Define Field by Expression
1
delay
1
delete
2
DELETE OBJECT
1
Delete Variable
1
Deleting values
1
deletion
1
delta
4
Denominator
1
density
1
density plot
1
department
1
Deployment
3
Deprecated
1
derivate
1
derive
1
derive fields
1
derived fields
2
descending
1
design
6
Desktop
6
Details
2
Dev Hub
1
dev tools
1
Developer Toolkit
1
Developers
7
devhub
1
dia
1
diagram
1
dicionário
1
diff
1
difference
3
Difference between to dates in years and months
1
different
1
Different Fields
1
different tables
1
differing levels of detail
1
dimenison
1
Dimensiom
2
dimension
26
Dimension as expression
5
Dimension ascending of Fiscalyearquarter
2
Dimension axes
1
dimension comparison
1
dimension grouping
1
Dimension grouping based on another dimension
2
dimension ignore filters
1
Dimension labels
5
dimension limit
1
dimension set analysis
1
Dimension with zero values in the measure
2
Dimensional Limit
1
dimensionality
2
dimensionality()
2
dimensionerror
1
Dimensiones
3
DimensionLimit
1
Dimensions grouping
1
dimensions in formula
1
dimensión
2
dimesions
1
dinamico
1
Direct Data
1
Direct Discovery
3
Direct Discovery Issues
2
Direct Query
7
disable Full Screen functionality
1
Disable Qlik Edit button for published apps
1
disappear
1
discrete line graphs
1
Disctinct
1
display
2
Display All Dimensions
2
Display data
1
Display image dynamically
1
Display label
1
display the remaining data as "others"
1
displaying in qlik
1
Distinct
9
Distinct field values
1
Distinct values
1
distribution
1
distribution plot
3
distribution quota
1
DistributionAnalysis
1
District of Columbia
1
divide
1
division
2
Do While Loop
3
Document Analyser
3
Document analyzer
2
document chaining
2
Document Connector
1
document name
1
Documentation
3
Does not filter calculation when selecting
1
doesn't display until selected
1
Dollar expansion
2
Dollar Sign
2
dollar sign expansion
1
don't match
1
donut
1
Double assign
1
double sort
1
doubles
1
doubt
1
Download
1
drawing tools
1
drill down
4
Drill Down by measure
1
Drill down diemnsion color
1
drill down master
1
drill downs
1
drill obiee click openotherView
1
Drill through Dimension Skipping level in Pivot table
1
Drill-Down
6
Drill-Down Bar Chart
1
Drill-through
1
Drilldown
7
drop down
4
drop down select
1
drop-down
1
Dropdown
2
dual
4
dual data type
1
dual function
4
Dual Set Expressions
3
Dual Use
3
Dual() field
1
duplicate
2
duplicate app hub
1
Duplicate data
1
duplicate row
1
duplicate row count
1
Duplicate Rows
4
duplicated
1
duplicated sheets
1
DuplicateID
1
duplicates
1
duration
6
Dyanmic Charts
1
dynamic
10
Dynamic Assignment
2
dynamic bins
1
dynamic bookmark
1
Dynamic Bookmarks
2
dynamic chart
1
dynamic chart range
1
Dynamic Charts
4
dynamic connection
1
dynamic dimension
5
Dynamic Dimension labels in Title
1
Dynamic filter
2
DYNAMIC FORMULE
1
Dynamic id
1
Dynamic Images
2
Dynamic KPI
1
dynamic labels
1
Dynamic Legend and Tooltip
1
dynamic measures
1
dynamic report
1
Dynamic selections
2
dynamic table
3
dynamic tables
1
dynamic title
2
Dynamic views
4
dynamic waterfall
1
dynamically
1
Dynamically include or Exclude Dimensions after TOTAL qualifier
1
DynamicColumns
1
DynamicFilter
2
Dynamics
1
Dynamics Data Reduction
1
e
1
E()
1
EC2
1
Edge Size
1
edit expression
3
Edit Template
1
Editing
1
editor
1
education
1
elasticsearch
1
ELB
1
Elementos Maestros
2
email
1
email alert
1
Email Notification
1
email URL
1
embebed objects
1
embed picture to title
1
Embed Sheet
1
Embedded
1
Embedded Video
1
embedding
1
Embedding the iframe in website
1
embedding video
1
empty
2
empty data
1
empty folder
1
empty on bottom
1
Emulator
1
encoding
1
end to end
1
enddate
1
endpoint
1
Engine
1
engine api
2
EngineAPI
2
engines
1
english
1
Enigma
1
enigma.js
1
Enter by rows
1
enterprise
5
enterprise version
2
Entitlements & Permissions
1
entrprise
1
EOD data
1
equal
2
Equivalent
1
erreur de somme
1
error
1
Error 403
1
ERROR EXPRESION
1
error handling
1
Error Load in Qliksense November 2018
1
Error Messages
1
errormode qlik Sense
1
Errors - Unexpected Behavior
2
Escape
2
ESTADOS
1
ETL
5
evaluate
1
event & action button
2
event date
1
Events
1
exact match
1
exam
1
excel
14
Excel data
9
Excel data sets to Qlik
3
excel export
2
Excel Export Logs
3
Excel Exports
4
excel file
2
Excel Pivot table
1
Excel report
3
Excel via ODBC
1
exception
1
Exchange
1
exchange rates
1
exclude
5
exclude data
2
exclude filter
1
Exclude Selections after TOTAL qualifier
1
exclude values
2
excluded selections
1
Excluded Values
2
excluded values alternative values
1
ExcludedValues
1
Excluir
1
Exclusions Loading script
1
exclusives values
1
exec
1
execute
1
Execute Command
1
execution failed
1
Exists
6
exit or move to next block
1
Exlude
1
Exlude measure
1
exp
1
expirado
1
Exploration Menu
1
Export
13
export api
1
Export button Qliksense
1
export data
4
Export data to excel from qliksense
3
export error
1
Export Friendly
1
export image
1
export object
1
export ppt
1
Export Script
2
export to excel
1
export to image
1
export to pdf
1
Exporting data
3
exports
1
expot
1
expresion
1
expression
315
Expression builder
4
expression editor
1
Expression Error
6
expression syntax
1
expressions IF in graphics
1
expressions straight table
1
expressión
1
Extended data
1
extended sheet
3
Extension
1
Extension Development
5
Extension Object
1
Extension Objects
8
Extensions
14
Extensions QlikSense
1
Extentions
2
External
1
Extract
2
extract info
1
extraction
1
Extrapolation
1
FABS in set analysis
1
Fact tables
4
fail to load
1
Failed jobs
1
failover
1
feature
1
Feb 2021
1
feb-2020
1
February 2019
2
February 2020
1
February 2021
1
Fecha
1
Fechas
2
Fetch
1
fetch last distinct values
1
field
13
field addition
1
field definitions
1
Field Load
4
field not found
3
Field Type
2
Field value
4
Fieldnames
1
fieldnotfound
1
FieldNumber
1
fields
9
fieldvalue
2
file
2
file limit
1
file-format
1
Filed
1
files
1
fill
2
fill rows
1
filter
88
FILTER BY DATE
7
Filter DataSource
1
Filter Date
7
Filter Dates
5
Filter dimension measure
3
filter field
1
Filter in data loading
1
filter label
1
Filter limits
1
Filter made with column headings
1
filter object
1
Filter only on some data
1
filter pane
12
filter panel
3
Filter Panes
2
Filter performance
2
Filter records based on condition
1
filter selections
2
filter substring dimension
1
Filter tables data on condition
1
Filter Values Remove Listbox
1
Filter Visualization
5
filter-pane
1
filterbymax
1
filtering
8
filtering dataset
1
filtering slider
1
filtermax
1
filterpane
2
filterpanel
1
filters
15
filtro
1
Filtros
1
financial charts
1
financial data
1
financial data analysis
1
Financial functions
1
Financial model
1
Financial Tables
1
financials
1
First Date
1
first sorted value
1
firstsorted
1
FirstSortedValue
19
firstsortedvalue based on set analysis calculated date
1
FirstSortedValue()
4
Fiscal
4
Fiscal Calendar
1
fiscal year
3
Fiscal Year Calculations
1
Fiscalyearhalfyear
1
Fix legend display
1
fixed variables
1
flag
4
flags
3
flashcard
1
flat table
1
Floating
1
floor
2
floor plan
1
floorplan
1
flow of data from qlik to db
1
fly
1
folder
1
folder connection
1
Folders
1
fomart_number
1
font
4
font size
1
font style
1
fonts
2
Footer
1
Footnote
1
for
1
for each
1
for each Next
2
for loop
10
For loop file store
2
for next
1
for-next loop
2
Force closed
1
forEach
1
Forecast
6
Forecasting
1
Foreign Key
2
format
11
format date
3
format numbers
1
Format Specification Item
1
format time
1
Formating
9
formats
1
formatting
13
formatting date
1
formatting dates
1
Formatting Rules
1
formula
17
Formula visible
1
formulas
1
Formules
1
Fort
1
found
1
fractile
5
Freelance
1
fron end
1
Frond-end
1
front end
3
Front End Help
1
Front end portal connectivity
1
front-end
1
frontend
1
full accumulation
1
full month
1
function
413
function list
1
functional analysis
2
Functionality
5
functions
6
functions in set analysis
1
funnel chart
2
Future values
1
Fx
1
gantt
6
Gantt chart
8
gauge
1
gauge chart
5
Gauge chart Limits
2
General Question
3,948
General Script Error
3
Generate month
1
generate values within datafield
1
generating a blank report output
1
Generation
2
Generic calendar
1
generic key
2
generic keys
2
generic load
2
Geo
3
Geo analytic
1
geo analytics
2
Geo key
1
Geo location
3
Geo Maps
3
GeoAggrGeometry
1
Geoanalytic
1
GeoAnalytics
15
GeoAnalytics Area Layer
3
GeoAnalytics Connector Error
1
geoanalytics Qlik sense
4
geography
1
GEOJson
1
GeoMapping
1
geometry
1
geopoints
3
GeoTag
1
GeoTagging
1
german
1
get data from table
1
GetAppList
1
GetFieldSelections
15
getObject
1
GetobjectMeasure()
3
GetPossibleCount
1
GetRegistryString
1
GetSelectedCount
5
GetSelectedCount()
5
getselections
1
Getting Dimension and Measure using Button
1
gettselectedcount and current year
1
getValue
1
ggplot
1
Ghant
2
GIT
1
github
1
github connector
1
gitoqlik
1
Give some idea to implement this logic in Qliksense
1
Global Selection Problem
1
Global Variables
2
Google Maps API
1
google sheets
1
Governance
1
governance dashboard
2
gradient
2
grafico
1
grand total
1
Graph
9
Graphs
1
greater than
2
group
2
group by
5
Group by in Load
4
GROUP BY ISSUE
5
Group data
1
Group dates
1
groupby
4
Grouped Bar Chart
1
grouping
3
grouping values
1
Groups
2
growth
1
growth rate
2
gráfico
1
Gráfico Mostrador
1
guid uniqueidentifier
2
Gysbert_Wassenaar
1
Hadoop
1
hash
1
hastag
1
Health Care
1
Healthcare
1
heat map
1
Heatmap
5
heatmap chart
2
Heatmap chart - visualization bundle
2
help
20
Help !
7
Help me
2
help needed
3
Help required
9
Help sheet
1
Help Text
2
HELP_NEED_RECOVER_APP
1
Henric_Cronström
1
HEX
1
hexidecimal
1
hhmmss axis
1
hidden
3
hide
3
Hide and show
5
Hide and show object
1
hide columns
1
hide fields
1
Hide measures in Pivot Chart Qlik Sense
1
Hide null value Legend in Qliksense
1
Hide Prefix
1
hide rows
1
hide sheets
1
hide sheets and show on click
1
Hide year in my report that does not select with the year filter
1
Hide zero
1
hiding data
1
HidingExpressions
1
hierarchical
1
hierarchy
17
Hierarchy Dimension
5
Hierarchy Level Filter
1
hierarchyID
1
High Availability
1
High Tech
1
highest annual sales amount
1
highest sales
1
Histogram
2
historical
2
historical data
2
history
2
Hive
2
hoja
1
HolidayList
1
Holidays
3
horizontal
1
horizontal dimension
1
horizontal line
1
hours
2
hover
5
hover color
1
How To
2
How to add hyperlink in Pivot Table as measure
1
How to avoid null values in Qliksense Cumulative Line Chart
1
how to creat shared common circle for shared Customer Group
1
How to create a new filter based on another filter values
1
How to hide a specific Measure based Selections made on Alternative dimensions in Qliksense
1
How to hide a specific Measure based Selections made on Alternative dimensions in Qliksense Combo
1
How to maintain one fixed dimension and one alternate dimension
1
How to make a chart appear based from 2 buttons
1
How to Remove Synthetic Tables in Qliksense
1
How to show Numbers and Text in Qliksense Bar Chart Label
1
How to Show the Dimension if its excluded based on selection
1
How to sort bars by measures level in Bar chart
1
HTML
7
html page
1
HTML pop-up extension
1
hub
7
hub font
1
hub fonts
1
Hub Streams
1
hubspot
1
huge data sets
1
hypercube
3
Hyperlink
2
Hyperlink apps
1
I have attached the file
1
I want to get total count of quarters .
1
iata airport code
1
Icon
1
icons
1
ID
3
Ideas
1
Identifiers
1
Identify
1
Identity
1
idle
1
if
20
IF & OR
2
IF AND STATEMENT
13
if clause
1
if condition
4
if condition with multiple values in Qlik sense
1
if conditions
1
If else
8
If Else Expression
1
If else logic with set analysis in qliksense
1
if expression
1
if function
2
IF Match
1
If match in Qliksense scripting
1
IF only
1
If stament
11
if statement
13
If statement Date range Add Months LasRefresh
1
If statement exclusion
1
If statment
2
If then and else
1
if&setanalysis
2
if()
2
if-condition
1
If...ElseIf
1
If...ElseIf cause
1
IF...THEN
4
ifcolumsnmatch
1
Ifcondition
1
ifelse
1
iferror
1
iframe
6
iframe integration
1
iframe integration.
1
ignore
2
ignore current selection
2
Ignore dimension
1
ignore filter
1
ignore null
1
ignore selection
1
ignore selections
2
ignore x-axis and display
1
ignoring selection
1
iis .net net windows atuthetication rest api RestClient networkCredentials
1
image
4
image in table
1
Images
7
Immer ein ausgewählter Wert
1
Import
3
import multiple excels
1
Important
1
Importes Negativos
1
in
1
In app
1
in qliksense
1
Incline
1
Include
2
Include Exclude filters
1
include filters
1
Include Nulls
1
include zero values
1
income
1
incomestatement
1
incomplete tables
2
Incomplete visualization
2
incorrect Avg in pivot table in Qlik Sense
1
Increase Font Size
1
incremental data
1
Incremental Load
11
Incremental Load on Date condition
1
independent field
1
Index
2
index table
1
index title header dynamic label column reference
1
indexing
1
indicator
1
indicator representation color
1
info bubble
2
InfoBubble
2
infoload
1
Informatica
1
inline
2
Inline Load
6
Inline Table
1
InlineTable
1
inner join
1
input box
7
input html
1
input value
1
Input variable
2
inputfield
3
Insert
2
insert row
2
InsertUpdate
1
Insight Bot
2
Insights
3
Insights Advisor
5
Installation
1
Installation - Upgrade
3
Installation Error
1
instructions
1
integrate
1
integrating web object in qlik sense app
1
Integration
1
Interactions
1
interface
1
Internal Server Error
1
Internet
1
InterNo
1
intersection
3
interval
5
interval date
1
Interval Dates
3
Interval Match
3
Interval Match with Multiple Keys
1
Interval Match with two tables
1
IntervalMatch
10
IntervalMatch on multiple fields with multiple condition in a table
2
INTERVALMATCH YOY
1
Intervals
2
Introduction to Machine Learning
1
Invalid expression
2
invalid visualization
1
Inventarios
1
Inventory
3
IOS
2
ipad
2
IRR
2
ISNULL
1
IsNull()
1
issue
3
issues
2
iteration
4
Iterative Calculation
1
iterative ranking
1
iterno
3
jagan
1
jagan mohan
1
javascript
8
javascript qlik sense
1
jira
3
Jobs Seeking People
1
join
23
Join Logic
1
Join or Mapping Performance
1
Join Query
8
Join Scripting
1
Join Table
2
join tables
2
joined tables
1
Joining
2
joins
1
jquery
3
JSON
10
JSON API
2
JSON Load
1
june
2
June 2019
2
June 2019. App Overview
1
June 2020
2
June18
1
June2020
1
jwt
1
JWT Auth- Error 400 Contact your system administrator
1
kaanerisen
1
Kafka
1
keep
1
keep the previous run qvd data in app RAM and load new qvd data only
1
keepchar()
1
Key
3
Key Icon
1
Keys
2
kmeans
2
kml
8
kml file
2
KPI builder
1
KPI Chart
5
KPI issue
3
KPI with if conditions
1
kpi's
2
kpis qliksense kpi object loading
1
kraken
1
Kurtosis
1
label
12
label change by filters
1
label expression
1
labels
11
lag()
1
landing page
1
languages
1
large
1
Large App
1
Last 6 months cumulative average
1
Last date
1
Last month
1
Last twelve months
1
last year
2
latest
1
Latest Data
1
Latest reporting month
1
Latest values
2
latestrecord
1
latitude
1
LAUNCH button
1
Layer
2
Layers
1
Layout
1
Layout & Visualizations
11
LDAP
1
lead()
1
Leaderboard
1
Leer nuevos datos
1
left
1
left join
4
Left Join between multiple QVD's
1
legacy
1
legend
8
legend colors manual
1
legend cut off
2
legend disappears
1
Legend incorrect
1
legend order
1
legends
2
LEN
3
length of days
1
less than
2
let
3
library colors
1
Licence
1
License
7
License monitor app
1
ligne
1
LikeTerms
1
limit
1
limit number of elements
1
limitation
2
limitations
4
limiting Dimension values
1
limits
2
line
2
Line Chart Dimension
8
line chart gaps
1
Line Chart get x value from y expression
2
Line Chart limitations
1
Line Chart Missing Data
2
Line chart Pivot table
1
Line chart points
1
Line Chart requirement
5
Line chart start point
1
line diagram
1
line geometry
1
line graph
6
line graph continuous Time
1
line layer
3
line_chart
1
linear regression
2
Linear Trend
1
linechar
1
LineChart
10
LineChartExpression
4
linegraph
1
linest_b
3
linest_m
3
Link
2
Link Table
12
link tables
1
Link to Sheet
2
linking fields
1
Links
1
linktable
1
LINKTABLE IN DATAMODEL
2
list
3
list all visualization ID of all QlikSense Application on server
1
list box
3
List Box expression
1
list box sort
1
list of values
1
Listbox
7
live data sheet
1
live value
2
load
23
Load Balancing
1
load csv field name position number
1
Load Data
18
Load Data based on selections made
1
load editor
4
load generic
1
LOAD if
1
load image
1
Load Multiple QVDs in QLiksense
1
load scrip
1
LOAD SCRIPT CONSUMPTION TABLE
1
load script editor
1
Load Script Error
7
Load Statement
3
load table
1
Load tables
1
Loadign Screen
1
loading
3
loading data
1
Loading of Data
4
loadinline
1
loadscript
3
localhost
1
location
2
lock
1
log
4
Log10
1
logfile
1
logging
2
logic
4
Logic Calculation
2
Logic Function
1
Logic in script
1
Logics
2
Login
2
login access
1
login button
1
Login help
1
Login Screen
2
Logo
2
logout
1
logout button
1
logs
2
long running task
1
longitude
1
lookup
6
lookup chart function
1
lookup function
1
lookupmax
1
Loop
18
loop in script
1
loop with multiple condition
2
Loop with peek or Fieldvalue
1
looping through a column to update another column
1
looping through tables
1
Looping variable script
3
loops
3
Loops and Iterations
5
Lorenz Curve
1
lost
1
LWLY Flag
2
machine learning
2
machine utlization
1
Macro
1
Magic Quadrant
1
mailto
1
makeweekdate
2
Making Selections
1
Manage .rpt file on Qlik
1
Manage Properties
1
Management
4
Mandatory Selection
1
Map chart
13
map dimension
1
map export
1
map legend
1
map object
1
Map Qlik sense
8
Map Visualization
17
mapa
2
MAPAS ESPAÑA
1
MapBubble Size
1
MapChart Aggr
1
Mapping
15
mapping load
1
Mapping load with calculated expressions or functions
1
mapping table
1
Mapping()
1
Maps
18
maps area klm sense
1
maps qlik sense data
1
mapsubstring
1
mapusing
1
mas de un id
1
mashup
20
Mashups
20
master calendar
15
master calendar error
1
Master Calendar with Sequence Dates
3
Master calendars
4
Master calender
2
master dimension
5
master dimensions
2
master element
1
master item
1
master item in expression
1
Master Items
15
Master Measure
4
Master Pages
1
Master Visualization
1
MAT
1
Match
11
Match and Pick
1
Match field value
1
match()
1
matching
2
maths
2
matrix
1
max
10
max (date)
2
Max - chart function
1
max date
3
Max Date Value
5
Max Function
4
max value
2
Max value next column
1
Max()
6
MaxDate
2
maximize
1
maximum date
1
Maximum value SetAnalysis Join aggregate
1
MaxString()
1
maxtring
1
measure
16
Measure Details
2
Measure Expression
18
measure formatting
4
measure in filter
1
Measure Label
2
Measure one
1
measures
8
Measures expressions
5
meatball
1
Media library
1
mediamovel
1
Median
2
Median Calculation
1
median line
1
mekko
1
Mekko chart
2
Memory
7
Memory Footprint
1
memory leak
1
Memory usage
1
menu
2
merge
2
Merge Rows
6
merge tables
1
merge values
1
Mesear vs Mesear N-1
1
Meses
1
Mesure
1
Metadata
3
Methodology
1
Metrics
2
Michael_Tarallo
1
Microsoft Excel
3
Microsoft OneDrive
1
mid
3
mid()
1
migrating servers
1
Migration
3
Migration of the Qlik apps
2
migrazion
1
mike tarallo
2
Mileston
1
milliseconds
1
Min
2
Min max Values
1
Min value for each hour
1
Min()
1
MIN_MAX_AVG
1
MinDate
1
Mini chart
1
mini diagram
1
Minichart
1
Missing
3
Missing Data
4
missing dates
1
missing dimension
1
missing dot
2
Missing Fields
1
missing records
2
missing right parenthesis
1
missing rows in the images
1
Missing Value
1
missing values
2
missingcount
1
missingdays
1
missingrecords
1
Mixed Granularity
1
mixing
1
ml
1
Mobile
1
mode
1
Mode()
1
Model Explanation
1
modeling
1
Modelling question
1
Models & Scoring
1
modifier types
2
modifier using dimension value
1
modifiers
2
MOM
1
monday
1
money
1
monitor app
2
Monitoring
4
Monitoring app issue
3
Monitoring apps
3
Monitoring Apps Data
1
Montagem de mapas com uma lista de endereços
1
month
5
Month Difference between 2 dates
1
Month End Dates
1
Month on Month Growth in Pivot table
1
Month Range Sum
1
Month Selection
3
Month year number to month
1
Month&Week
2
Monthly and Weekly Data
1
Monthly trend
2
MonthName
3
MonthNum
1
monthsago
1
monthstart
1
MonthToDate
1
most frequent
1
most recent record
1
most used
1
mouse-over
1
Moving annual total
2
Moving Average
3
moving column
1
MTD
4
Multi dimension chart
1
multi kpi
6
multi line chart
1
multi-dimensional pie chart
1
Multi-KPI
3
multi-node
2
multi-value picklist filter
1
MultidimensionChart
2
multinode
2
multiple
3
multiple apps
1
Multiple apps one data set
1
multiple charts
2
MULTIPLE COLUMN EXISTS
1
multiple columns
1
multiple common columns
1
multiple conditions
2
Multiple conditions in an order when using AND operator Qliksense
1
Multiple Criteria
2
multiple date dimensions
1
multiple dimensions
5
Multiple fields
2
multiple files
2
multiple filters
2
Multiple foreign keys
1
multiple if statements
1
multiple lines
2
Multiple Master Calendars
1
multiple measure type
1
multiple measures
2
multiple measures bar chart
1
Multiple Qliksense server
1
multiple relationships
1
Multiple Rows
3
Multiple Selections on Accumulated Chart is not working as expected
1
multiple set analysis criteria
1
multiple sheets
1
multiple tables
1
Multiple text
1
multiple values
1
multiple year data
1
Multiplication
1
multiplying expression
1
must_include
1
my work
1
mysql
3
named set with qlik
1
Narive chart
1
natural language
1
Natural Language Processing
1
natural language queries
1
Navigation
1
navigation button
2
navigation button extension
1
navigation buttons
1
need it urgent
1
negative
2
negatives
1
nested
4
nested Aggregation
2
Nested For Loop
1
Nested If
5
Nested Sales
1
nested set analysis
1
Network
2
network chart
5
Network days
1
Network Path
1
Networkdays
3
Networkdays()
1
NetworkDaysexcludingholidays
3
new
2
New data
1
New Fields
3
new in qliksense
1
New Qlik Sense
4
New Qlik Sense November 2018
1
new table
1
New To Qlik
15
New to Qlik Community
1
New to Qlik Sense
24
new to qliksence
2
new to qliksense
2
New to QlikView
2
new user
2
New User Training
2
new-to-qliksense
1
newbie
1
news
1
news feed
1
NewtoQlikView
1
next
1
NLP
3
No Accumulation
1
No Exist
1
node
1
Node Size
2
nodes
2
normal distribution
1
normdist
1
Not
3
Not a Question
43
not exists
1
Not Format
1
not null
1
not showing all symbols added
1
not stacking up to 100%
1
not updating
1
not working
1
notokesavailable
1
Nov 2018
1
November
1
November 2018
4
November 2018 Release
2
November 2019
2
November 2019 Release
1
November2018
1
now
2
NPRINITNG POWER POINT
1
NPrinting
12
NPrinting 17
2
NPrinting 18 Field to cycle
1
NPrinting CC Email Task
1
NPrinting Designer
1
NPrinting Engine
1
NPrinting QlikSence filter substract30days
1
NPrinting Report
1
Null Display
5
Null in Qlik Sense after load
3
null on ui
1
Null value
5
Null values
3
null values in pivot table
1
Null Values to be representented as Others in Pie chart
1
Null Values to be shown as Others in Pie Chart
1
Null()
2
NullCount
1
Nulls
2
nullvalue
1
num
3
Num function
3
number
3
number format
7
number formating
2
number formatting
3
Number Months
1
number of days
1
Numberformat
3
numbers
2
Numerator
1
Numerical Values
1
Numeros Negativos
1
NVL()
1
object
4
Object Extensions
1
Object level section access in Qliksense
1
Object not found
1
Object Properties
4
Object Value
1
ObjectID
1
objects
4
Obter dados de latitude e longitude a partir de uma lista de endereços
1
occurences
1
ODAG API
1
ODBC
2
ODRG
1
ODSO
1
Office365
1
offset
1
OLEDB
1
OMIT
4
On Demand
2
on demand app
1
on demand app generation
4
On Demmand App Generation
2
on fly
1
on open
2
on qlik
1
on time delivery
1
OnDemand
1
One App
1
one dimension
1
one selection to lead to second selection
1
One too many
1
onedrive
1
ongoing month
1
online
1
only
1
Only function
2
only one selected
1
open_qvf_from_qlikview
1
Operation Monitor
3
Operations Monitor
6
Operations Monitor App
1
operators
2
opposite
1
OPTIMIZATION
14
Optimized Load
2
Option
1
or condition
1
OR filter pane
1
OR in Set Analysis
1
ORACLE
2
Oracle 11
1
Oracle Database connection
1
order
2
order by
3
Order of calculation
1
ordering
1
OrgChart
1
OSUser
5
OSUser()
1
Other
11
outer join
1
outer joins
1
outlier
1
outliers
3
outstanding
2
overlap widget
1
Overlapping
1
overlapping objects
1
own
1
owner
1
owner app
1
p
1
P &L Pivot Chart single column background color change
1
P function
5
P&L
4
P&L Chart
1
P&L pivot
2
P&L pivot chart extension
1
pagination
1
Palete Colors
1
panel
1
Parallel Session
1
parameter
1
parameters
3
Parametrized variables
1
Parent-child relationships
3
Pareto
1
Pareto analysis
1
Pareto count
1
parse
1
parsing
4
partial match
1
Partial reload
1
partial sum
1
Passing parameter value via variable to a URL
1
passing string variable as an argument
1
password
2
patch
1
Patching
1
Patric Nordström
1
PDF
4
PDF Export
2
PDF Report
1
Peek
8
Peek ()
1
PEEK as expression
1
Peek is slow
1
peek()
5
Pekk max record on selection of date range
1
People Seeking Internship
1
People Seeking Jobs
3
Peoplesoft Dashboard Design and Datamodel
1
Per Cent
1
percent line chart
1
Percent QlikSence
1
Percent QlikSense
1
percentage
3
Percentage based on month
2
Percentage changes
1
Percentages
14
Percentages in pivots by subtotal not Grand total
1
percentaje column
1
Percentile
1
PercentRank
1
Performance
17
Performance Dashboard
3
performance issues
5
performance optimisation
1
performance optimization
1
period
1
Period of time
1
period time
1
Periodo
1
Periods
2
permissions
1
Permutations and Combinations
1
persistence
1
personal sheet
1
Pharma
1
picasso
1
picasso.js
1
pick
6
pick()
1
Pick(Match())
4
Picture
1
Picture not shown
1
Pictures based on Data
1
pie chart
9
Pie chart and color
1
Pie chart and colour
1
pie chart and percentage
1
Pie chart help
1
pie graph
1
Piechart
3
Pivot chart
2
pivot color
2
pivot columns
1
pivot data
1
Pivot Dimensions
11
pivot expressions
3
Pivot Filter
4
Pivot Headings
1
Pivot Measure
12
Pivot Multi Dimension Sort
2
Pivot Null to Zero
1
pivot rolling
1
Pivot Sum Column
2
Pivot Tabelle fehlende Konstellationen Formatierung
1
Pivot table - % of totals
1
Pivot table background color
2
Pivot table behavior
2
pivot table colour dimension
1
pivot table column
2
pivot table expanding column dimension