Explore in-depth resources and join QlikView-specific discussions with experts around the globe.
Hello QlikView Users,
If you have any questions regarding installing QlikView please check out this post on the Qlik Support Updates Blog. There is a new step-by-step guide available that helps troubleshoot common issues that can occur. It also includes pictures to walk you through the installation. It is based on the Help site installation guide but hopefully the add-ons will help with the process.
Be sure to subscribe to the Qlik Support Updates Blog as well! The blog offers guidance from your peers on hot topics, announcement of new software releases for Qlik Sense, and updates regarding Qlik from the VP of Customer Success, Daniel Coullet.
Kind regards,
Qlik Digital Support
Hi,
The tooltip that is getting generated on my heatmaps shows the conditions that were used to create those (default feature).
Now I want to customize this, and add 1 more field there.
For example, 'Comments' is one of the field that I already have.
So, i need the value of comments to be displayed in the tooltip along with the default display.
Can you please suggest how I can achieve this?
Thanks in advance !!!!
My company recently moved to SSO for Salesforce . Since then I'm not able to connect to Salesforce and get the following error ... any ideas how to fix this
We have scheduled many tasks which performs different functions like loading apps, repositories etc. From past 2 days, though the tasks run status is marked as Success, but apps are not refreshing/loading. Seems there is load failure. It means Qlik is showing all is well whereas there is some issue. Has anyone faced similar issue yet? Why and in which scenarios Qlik may give false success status? Please suggest.
Hi,
I need user distribution details for each and every user documents.
I tried to get the details from DistributionDetail.xml but the file is not up to date.
so please suggest me how to get latest user distribution list.
Hi all,
I'm trying to define the section access on my qlikview but it doesn't work once I try in the AP (locked out).
Find attached a sample of my security.qvd (ACCOUNT_KEY fromat is like {...4G5HJ...} all numbers and uppercase letters).
section access;
LOAD upper(ACCESS) as ACCESS,
upper(NTNAME) as NTNAME,
upper(ACCOUNT_KEY) as ACCOUNT_KEY
FROM
[..\..\Security.qvd](qvd)
WHERE 1=1;
section Application;
FACT:
LOAD ACCOUNT_KEY,
...
FROM X;
Any idea what's happening?
If I set myseld as "USER" it works for "*" and restrics correctly for specific ACCOUNT_KEY.
I recently replaced my laptop and installed QlikView the same way I did a few years ago - same version and even tried newer versions.
Normally I'd try to open one of my old files and I'd be prompted with a "recovery" option. When I look in the Help data, it shows 4 "PE recoveries remaining" - confirming that I have not used any...but I never get the prompt that I even have the recovery option. I get a "failed to load".
Does anyone have any idea how to "force" a recovery? I have tried uninstalling, cleaning up the registry, copying my AppData/Roaming/QlikTech from older computer, the ApplicationRescue and ScriptRescue and loading with /nodata...all those options for all the posts I have found but still no luck.
Can anyone help?
Dear all ,
Please assist we are unable to view the dashboards in QlikView AccessPoint portal via google chrome / Edge .
please find the attached screen. Thanks !
Hello,
I have a problem with sorting a field in the active selection.
I have a "Period" field which is well sorted (descending order) in the original app (qvw) but when I pass on the accesspoint, the modalities of my field are out of order.
This only happens on a particular report.
So I did a comparison with another report (which doesn't reproduce the problem), which led me to uncheck one setting: Setting > Document Properties > Server > Allow Server Objects
This action allowed me to "solve" my problem since my sorting is done correctly.
However, if I backspace (recheck the param) I do not reproduce my problem.
This solution does not seem to me to be viable.
I also tested to change browser (tests on IE and Chrome) but that does not change anything.
FYI, I'm using Qlikview 12.50.20000.0
Do you have any idea for solving this problem?
Thanks in advance,
Caroline
How can i change the Source in Qlikview Server application, From AX to D365 for a field. Data source for a field has moved to AX D365 and we have to click on the source to D365 to see the report. Attatching the Screen shot for the same below.
Hello,
Experiencing a new issue we've had in production for years.
Since we upgraded to May 2021 SR2 the embedded URL's aren't working inside our Qlikview dashboards.
They are implemented as such:- ='Name' & '<url>' & 'Link'
Real example:- PIL_InvoiceID & '<URL>' & PIL_InvoiceImageURL
The above is implemented inside a straight table. I also tried putting the URL in to an action on a text object. This also doesn't work.
The experience is that the cursor changes to a hand, you click and nothing happens. No pop up blocked, no attempt whatsoever to open the link.
This has been working on versions prior to our May 2021 SR2 upgrade.
I can expose the URL and copy and paste that in to an address bar and it works.
I've tried the May 2022 initial release version in a dev environment that came out this month and I'm having the same problem.
Anyone else experiencing the same issue / know of a possible solution?
Thanks,
Ben
Hi,
I am using sheet actions to pre-select some fields on a particular sheet when the user opens it.
This works fine when I want to make a single selection (e.g. Field=Colour, Search String = 'Yellow').
However I can't figure out how to make multiple selections in the same field (something like Search String = 'Yellow','Blue'). The help manual clearly indicates this should be possible:
Select in Field: "Selects the values and fields that are specified. In the Search String you can specify a search mask, e.g. (A|B) will select both A and B."
I can't for the life of me figure out how to write this, I can't seem to get the syntax right. I have tried all of the following:
='Yellow','Blue'
=Yellow,Blue
=('Yellow','Blue')
=('Yellow'|'Blue')
=('Yellow'&'Blue')
=('Yellow' and 'Blue')
Anyone got this to work? Other threads raise this question but the only answers seem to be 'use a macro' (http://community.qlik.com/forums/p/23382/89368.aspx#89368). I'd rather not use macros jsut for this as I have not used macros so far, and would be good to keep consistent.
Thanks!
I want to query CDS views from SAP/HANA with Qlikview version 12. Unfortunately, this does not work. There are always 0 records generated. If I want to query real tables and fields, it works without problems.
Can you help me here?
Best regards
Martin
Hello all,
I would like to keep track of some variables that I calculate thanks to set analysis.
( My idea was to store the values of the different variables in a QVD with a column for each variable and everytime i reload it adds the new values of the variables inside the qvd as a new line. Also when I reload it import the previous values of those variables to make an historical data graph )
So there are a lot of topics on these subjects ( like this one https://community.qlik.com/t5/New-to-Qlik-Sense/Incremental-Load-on-QVD/td-p/1309066 )
But It appears that i don't fully understand.
Because what I did was:
1) Declare the variables ( I was not sure if I had to put an equal sign or not inside
Let v_indic_1 ='count({(1<[field ]={"fvalue"}>+.... ])';
Let v_indic_2 ='=count({(1<[field]={"value "}>+1<[field]=] .... )';
2) Load previous values of variables inside the qvd and concatenate with the new ones then store all in the qvd.
ALOS:
LOAD v_indic_1,
v_indic_2,
v_indic_3,
v_indic_4,
v_indic_5
FROM
[...\ ALOS.qvd]
(qvd);
concatenate
Load
'$(v_indic_1)' as v_indic_1,
'$(v_indic_2)' as v_indic_2,
'$(v_indic_3)' as v_indic_3,
'$(v_indic_4)' as v_indic_4,
'$(v_indic_5)' as v_indic_5
AutoGenerate 1;
Store ALOS into [ALOS.qvd] (qvd);
That works but it stores the text of the formula inside the qvd and not the values of the variables.
I tried also without the ' ' to load the new values of variables ( '^(v_indic_5)' as v_indic_5...
If someone has an idea that would be with pleasure to listen 🙂
thanks for reading !
Hi All,
I need help in a Qlikview application where one of the field's data source has changed from AX to D365. But by default it is still showing AX as a source. How can i make changes so that it should automatically show D365 as a source when i select that field?
Hey everyone,
I built a variable to dynamically alter the number formatting of whatever expression I use it with, by means of a variable parameter. It works perfectly on normal expressions, but seems to completely break when there are IF conditions and/or AGGR functions within the expression. I'm running on Qlikview 11.20
Variables used:
vR=Just a button to alternate between the number formats
vNumberFormat=
Pick(Match($(vR), 0, 1, 2, 3),
'#,##0 ;(#,##0)',
'#,##0.00 ;(#,##0.00)',
'#,##0.0 ;(#,##0.0)',
'#,##0 ;(#,##0)')
vDivide=
Pick(Match(vR, 0, 1, 2, 3),
'1',
'1',
'1000000',
'1000')
vNumFormat=
Num(($1 / $(vDivide)), '$(vNumberFormat)')
Example of an expression using the variable which returns an error:
=$(vNumFormat(if(Dimensionality()=1,
Aggr(RangeSum(Above(sum({<FIN_YEAR={$(vCURRENTYEAR)}>} IS_ACTUAL_MTD),0,RowNo(TOTAL))),[TOTAL I/S]),
if(match([IS LEVEL 1],'Income', 'Equity-accounted earnings'),sum({<FIN_YEAR={$(vCURRENTYEAR)}>} IS_ACTUAL_MTD),
if(match([IS LEVEL 1],'Expenses','Finance charges', 'Tax'), sum({<FIN_YEAR={$(vCURRENTYEAR)}>} IS_ACTUAL_MTD)))
)))
Any help would be appreciated, thank you.
Hey guys! Is it possible to buy a perpetual QV license? I know Qlik changed to an subscription model but is it risky to buy a maybe „used“ license? Anyone knows where to find used a license? Thx!
Hi All,
I need to calculate the sales growth for latest 12 months comparing with previous 12 month against Yearmonth & brand
Rolling 12 months for latest 12 months with Two Dimensions:
Dimensions:
1. YearMonth
2. Brand
Note: Need show to latest 12 months
Expressions:
Formula: (CY-PY)/PY
CY : Latest 12 months i.e.,(Aug-15 to Jul-16)
PY : Previous latest 12 months i.e.,(Aug-14 to Jul-15)
Expression Am using:
(Sum({<YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -11), 'MMM-YY') & '<=' & Date(Max(YearMonth), 'MMM-YY'))"},
Year=, Month=>}Sales)
/
Above(Sum({<YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -23), 'MMM-YY') & '<=' & Date(AddMonths(Max(YearMonth), -12), 'MMM-YY'))"} ,
Year=, Month=>}Sales), 12)) - 1
My issue is
when iam using the second dimension (Brand) the expression part is not working and it showing like no data to display
Attached the sample data
Regards
Hemanth
Hello,
I'm facing a problem with a column that has more than 3000 characters and doesn't appear as a value in qvw.
I was getting this field in the QvdGen file from tables as a ''character varying'' and when I test to see if the field has value then I was getting a null value. When I converted this field to text and I did a quick load seems to be working and the value was there.
The strange thing is when I load this field into qvw the value doesn't appear. Is there any limitation to the text?
Many thanks in advance,
PA
Hi, i'm New at Qlikview, and i'm trying to simplify my code but i can't do it.For example this is my code when I load information from an excel source.
Load
Period,
[Company Code] as [CC],
Amount,
Amount * -1 as [Negative Amount],
[Negative Amount] /1000 as [Neg Amount in miles]
The code write with Bold, doesn't work, probably because "[Negative Amount]" it's not recognized from the source of the excel. But I need it to work, cause i'm on more complex formulas, and I need them to look easy to understand.
Pleasee help,
When accessing the accesspoint from the user's PC to QlikView Edge (ie mode), the qvw file does not open.
Of the two currently running servers, one server opens fine without any other settings, but the other server does not.
I checked the qmc or server settings on both servers, but I don't know
What is the difference between the two servers?
how can i open qvw?
please tell me how
version : April 2021 SR2 12.60.20200