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
Hello Clever People,
Please find attached.
1. A bit about the data. Dimension "Service" has a specific value, called "Bucks"
2. I have a normal calendar as well as one for Fiscal Year (which runs from July to June of next year)
3. I have "Actual" values (which are indicated with 'HasValue' = 1) and Budgeted Values ('HasValue' = 0). (You will notice that the "highest" Financial year (2021/2022) contains only values with 'HasValue' = 0 . common sense.)
4. What I want to achieve on the Graph with the blue heading..
4.1 if the user DOESNT select a financial year - it should just go to the "latest" month that 'HasValue' = 1 MINUS 13 months.... The -13 doesnt work - I think it has to do with the Financial year in the Set Analysis...
4.2 if the user selects a Financial year (2020/2021) = same must happen....it should just go to the "latest" month that 'HasValue' = 1 MINUS 13 months. That DOESNT work, because the Period will fall in another FY - that is why I am trying to subtract 1 from the FY. (I got the amazing advice from @rwunderlich to use Firstsortedvalue on the FY - since it is a dual field - not sure how to use 13 in the Rank part of FirstSortedValue)
5. Any advice getting this chart to work. Maybe I am off on a tangent and there is a better way to do it?
Thank you
Please have a look at the simplified example of my qvw.
An employee works for two departments. I have to count the distinct months this employee works.
I wonder why the result is presented at just one department. I need the result for both of the departments
We are using version april 2019
Hi Community
I need to import a TXT file on Qlik for analysis. the issue is : my TXT file have two columns with different names
1. 'STATUS'
2. 'WORK STATUS' (with different kind of respective data)
'STATUS' have 1,6 and 'WORKSTATUS' have 1,4,5
In process of importation QLIK consider those two columns in same name 'STATUS' and then have an error message (not Unique).
I have try to rename one of them on loading 'STATUS' AS 'STATUS_2' now the issue is QLIK give data of one of column for both of them. STATUS' = 1,6 and 'STATUS_2' = 1,6 also...........I lose column that give me : 1,4,5
Please Help
Hi Team,
I have created the PRJ_Folder_Creation.qvw application to create prj folders and running via batch script. It is common application for all team members. So multiple instance created when more then one team member execute the batch file at same time.
Batch Script: PRJ_Folder_Creation.bat
C:\Program Files\QlikView\Qv.exe" /r "D:\PRJ_Folder_Creation.qvw"
Batch file has to execute based on condition, have to check PRJ_Folder_Creation.bat is already 'running' or 'not'.
If it is running have to trigger a msg as ' Already running, Please try some time later' and batch has to exit, If it is not running has to start above mentioned batch script.
Please suggest to handle this issue. Suggestions are appreciated.
Thanks
there are 2000 properties in 10 different countries. Each property has a purchase price.
there are 5 appraisers. Each of them reassess some of the 20 properties.
This leads us to two tables.
1: property, country, purchase price, date of sale announcement, status of sale
2: appraiser, property, estimated price
Table one shows property, country, purchase price overruled by estimated price of selected appraiser if exists (called "current price")
IF(
ISNULL(ONLY([estimated price by appraiser]))
,ONLY($(setexpression) [purchase price])
,ONLY([estimated price by appraiser])
)
where $(setexpression) restricts to specific timeframe when sales have been announced first as well as to specific status of sale
wanted: table two should show the sum of current prices per country (formula above aggregated by country) restricted to properties that fit to $(setexpression) in general
Hello all,
I have as an example:
Field_a |
x |
y |
z |
I want to do some calculations based on the value selected in Field_a (as an example GetFieldSelections(Field_a)=y)
let vTest_y=B0_y + B1_y + B2_y;
B0_y, B1_y, B2_y are already loaded as fields.
I want only to catch them based on the selected value and to affect the calculated value into new variable named vTest_y.
Any help please?
Thanks in advance.
I am a total novice but my company has recently started using qlikview for some of our charting and analysis, we are in a small office and are a bootstrapped startup so learning how to build dashboards would be incredibly useful. I've been able to figure out a bit but really need some kind of guided course - any one have any experience? Ive found classes that are super expensive offered through qlikview or qlikview development consultants but don't really have the funds for such a thing. Something free would be great. Ideas greatly appreciated!
Bonjour,
Je débute sur Qlikview et j'ai besoin de calculer le nombre de jours calendaires en fonction de mon filtre de période.
par exemple je sélectionne janvier février et mars 2021 je devrais avoir (31+28+31=90) si je sélectionne février mars avril 2021 je devrai savoir (28+31+30 = 89).
j'ai essayer la formule suivante : =Day(MonthEnd([Mois-Année])-MonthStart([Mois-Année]))+2
mais ce ne fonctionne pas à partir du moment ou je n'ai plus la dimension "mois" dans mon tableau.
Je ne peux pas laisser cette dimension car au final il me faut une ligne par personne.
Merci d'avance.
COrdialement,
Hello everyone,
In a while loop I am supposed to calculate a value in each iteration.
As an example:
set b=2;
set a=0;
set n=100;
set delta=(b-a)/n;
do while t<b
let W=W+$(t)*$(t);
let t=t+delta;
Loop
For post-processing, I would like to store these values in a field to be able to display them later in a diagram. For the chart I would need dimension and expression.
Dimension=values of t
Expression=values of W
Can someone please help me?
Thank you very much in advance.
With kind regards
Hello Experts,
I need some help.
I have been trying to do the following,
TABLE 1:
LOAD ID, B,C, D, E from [ lib://A.qvd] (qvd)
TABLE 2:
LOAD ID, X, Y from [ lib://B.qvd] (qvd)
TABKE C:
LOAD ID, B, C, D RESIDENT TABLE 1;
left join
LOAD ID, X, Y RESIDENT TABLE 2;
DROP TABLE 1
DROP TABLE 2;
TABLE 3:
LOAD ID, B,C, D, E from [ lib://X.qvd] (qvd);
TABLE 4:
LOAD ID, X, Y from [ lib://Y.qvd] (qvd);
TABLE D :
LOAD ID, B, C, D RESIDENT TABLE 3;
left join
LOAD ID, X, Y RESIDENT TABLE 4;
DROP TABLE 3;
DROP TABLE 4;
Now at this point I have 2 tables, TABLE C and TABLE D, with similar column structure , i.e. ID, B, C, D, X, Y , where, as the column names matches , it is creating automatic association in QS by creating a synthetic key on all columns which is expected. But I want to restrict that and create a table by making the join based on column C and D only. is there any other ways than to renaming / creating aliases for all the columns other than C and D?
Hi All,
I have an issue with transferring selection from one report to another. Most frustrating is that process is working perfectly on Dev environment but once we move the same files to Prod environment - selection is not being transferred.
I went through a bunch of articles of how to set it up in Qlikview and I think that I got it right how the mechanism works.
I need help in finding if there is any particular setting on server that can prevent states of being transferred between reports? I did compare server settings from C:\ProgramData\QlikTech\QlikViewServer\Settings.txt and indeed there are some differences between Dev and Prod servers but I have no idea which can be responsible for the unexpected behavior.
Please help.
DeltaBI
Hello,
We had a qlikview E2620 server (2.1Ghz , 8 cores, 126 GB RAM) virtualized on proxmox. We decided to change the processor to bring more power.
We switched to an AMD EPYC 7302P (3Ghz, 16 cores, 256GB RAM).
We had during the transfer of the vm, quite a few problems with a windows process "system". It was consuming all the cpu resources at startup. It was doing a check on the ram, and all the processor was used. (99%).
My colleagues managed to solve this problem by dedicating 10% of the total ram to the hypervisor. Windows now starts normally.
I have some reloads that now take longer than before.
A small reload of 2 minutes now takes 4 minutes.
Some big reloads of one hour still take the same time while others take 20 minutes more.
Not all reloads are impacted by this change. I don't have any common point between reloads like for example the database or the use of a qvd.
Everything is random.
We have applied all the settings recommended by qlikview found here :
https://community.qlik.com/t5/Scalability/Quick-tips-8-Server-settings-for-best-performance/td-p/1487578
What are we missing?
I was really expecting an improvement of reloads and performances.
Maybe not an improvement of RAW reloads, but at least an improvement of transformed qvd reloads.
Thanks to all.
Hi,
I have created a variable for company and I also created a button to pass this variable to micro in my application. I couldn't pass this variable to macro when I click on button.
Please provide macro to pass a variable and suggest solution on this.
Many thanks in advance.
The Copy Data special icon (Copy to Clipboard) for a straight table is available in QV designer, but not in chrome browser. I am able to see the Menu, the Print and the Send To Excel icons, but the option to Copy to clipboard is not available.
Any advice would be greatly appreciated. I have found that Copy to Clipboard is an alternative for when the Send to Excel option fails or times-out. With both not working, I am out of options.
Hi.
I am still facing the problem concerning "QlikView Containers: search magnifying glass disappear before you can write the search string". I found an article regarding this topic:
https://support.qlik.com/articles/000086523
Even though the article says, that this bug got fixed for version 12.50 and higher, our search-bar dissappears immediately if the listbox is packed in a container. Does anyone have informations about this topic? Currently we are using Version April 2020 SR3, would it make a difference if you would use April 2020 SR4?
Greetings
Jakob
I'm trying to place two conditions on a color. I'm using the below expression for red, amber, green but I want to write something along the lines of IF (SUM([Current]-[Original]) < 1 and [DISCUSSION FLAG] = 'X', GREEN().
How do I write 2 conditions for a color based off of 2 data points?
IF (SUM([Current]-[Original]) < 1, GREEN(),
IF ([AT RISK] = 'X', YELLOW()
,RED()))
MVP
17721MVP
7645MVP & Luminary
7192MVP
6731MVP
4700MVP & Luminary
4485MVP
3489MVP & Luminary
3395MVP
3125MVP
2868