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

Hello all,

I have as an example:

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.

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