Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.
Subscribe for updates
Featured Content
-
QlikView Documents
Recent Updates to QlikView Boards
Hello Qlik Community, We recently made a few updates to simplify the navigation for the QlikView discussion boards. The discussion boards have b...
Recent Discussions
Recent
Unanswered
Unsolved
Solved
-
New to QlikView
Mail Alerting doesnt work
Hello,I tried to install an Email Alerting for Failed Tasks recently. So I set up the Mail Server Details in System -> Setup -> Mail Server. I r...
-
New to QlikView
Sheet Properties menu pop up
Whenever I reload the data from the script editor, the Sheet Properties menu pops up. This first happened yesterday and has never happened previo...
-
QlikView App Development
How to paste chart in particular PowerPoint shape
Hi,How can I paste chart in particular shape in PPT slide?This is part of code:Set CurrChart = ActiveDocument.GetSheetObject("CH01")CurrChart.RestoreC...
-
QlikView Integration
Is QV 11.20 compatible with Windows 2016 ?
Hi guys, We're moving our datacenters to another location where windows servers are Windows 2016 and this is a must.Our Qlikview server is versio...
-
QlikView Scripting
date(Floor(MyDate),'MMM')
Hi!I have a timestamp and have managed to make it into only YYYY-MM-DD by using date-floor-function. It works perfectly!When only using date...
-
New to QlikView
Incremental Load
Good morning;I ma making one incremental load where I insert new rows, updated rows and eliminate rows.The problem is the base is not complete, becaus...
-
QlikView App Development
Display only those records which have one particular value for all records
Greetings! I hope i can explain this well enough. I have a table with columns Number, Col1, Col2 which can be considered as a unique identifier. Colum...
-
New to QlikView
Apply Map Function
Maptab: Mapping LOAD * INLINE [ID, NAME 1, A2,3, C4, D5,6, E ];This is my mapping tableusing apply map i want replace null value wit...
-
QlikView App Development
how to use a color using a set analysis in a chart
hello,I have a chart with 1 dimension and 3 measures (cf picture 1)one of them should display an colored arrow depending on the sign of a ratio ...
-
New to QlikView
wildmatch in expression
i have this expression count(if(wildmatch(sm_no,'US*'),left(sm_no,9),amount_lc))in that condition i am trying to get the sm_no who start wi...
-
New to QlikView
From Date & To Date Selection
HI ExpertsPlease help me with the below....please.I need to create a from date and to date calendar in my sheet. and it has to select the dates from o...
-
New to QlikView
Range sum is not working properly
Hi Team,I am trying to calculate running total by using rangesum function=Aggr(RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0,RowNo())), [Prod...
-
New to QlikView
aggregate the column values
Hi all,i have a column in pivot table product% it is showing % correct but i need to show tha...
-
QlikView App Development
$ Sign in Y axis not always working
Hi All,Greetings for the day.I have a combo chart showing Sales and Units by Period. I need to show $ sign in Y axis. I handled this using Static Step...
-
New to QlikView
Dynamic LOAD Variable
Hello,Is something like thisIF(GRUPPE1='3',LAND & SPRACHE & GRUPPE5 & GRUPPE6 & BLTUGP as GUVKONTOGRUPPENKEY,LANDISO & BLTSPRISO &...
-
New to QlikView
PST to GMT or UTC
Hi Folks,I am having DB data which is logged in PST format and i need to convert into GMT or UTC with Daylight saving. Currently i am using Times...
-
New to QlikView
How to switch between months with the values only changing
Hi everyone!I'm new in using qlikview, I was wondering how can I create for example when I clicked a month, let say January it will show specific valu...
-
QlikView Layout & Visualizations
Border around the straight table or pivot table
Hello ALL,I want to have a different color border around my straight table or pivot table . Please let me know how to change the color of t...
-
QlikView App Development
Transform and Transpose Table
Hello. Can you help to dynamically transform and transpose a table :IDProduct.NoProduct.Value1231030012320100123302002223012322220432222101511112...
-
QlikView Layout & Visualizations
Dimensions as Row in a Table
Hi, I have a table like thisPer_IdFirst NameLast NameCompanyCountry and data likePers_IdFirst NameLast NameCompanyCountry1ABCD2XYZWWhat I want to...
Nicole_Tamms
Employee
Sue_Macaluso
Community Manager
Top Resources
- How To /Missing Manual (25 articles) 219
- Useful Qlikview Macros 208
- Calculating rolling n-period totals, averages or other aggregations 192
- Set Analysis: syntaxes, examples 161
- QlikView 11 Developer Tutorial 152
- New to QlikView Videos 118
- QlikView How To (or Tips & Tricks) Application 104
- How to use - Dimensionality() 102
- NULL handling in QlikView 74
- Advanced topics for creating a qlik datamodel 73
Top Participants
-
sunny_talwar
MVP
16847 -
swuehl
MVP
7397 -
jagan
MVP & Luminary
7155 -
Gysbert_Wassenaar
MVP & Luminary
6569 -
tresesco
MVP
4444 -
marcus_sommer
MVP & Luminary
3882 -
Peter_Cammaert
MVP
3450 -
rwunderlich
MVP & Luminary
3122 -
MarcoWedel
MVP
3070 -
maxgro
MVP
2815
Events
Qlik Bracket Challenge
The Qlik Bracket Challenge starts when the men’s college basketball bracket goes live March 18th.
Get notified when the contest is open so you can compete for the $100,000 prize.
March 18, 2019
United States of America