QlikView

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 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

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!

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. 

YourTexasBenefits

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