Hi All,

I do have 2 virtual machines in Azure. One is DEV Qliksense machine and the other is restored machine from the back up of DEV (using Azure backup). Now both machines have the same computer name but different IP's.

Our requirement is to use the restored machine when DEV system faces a disaster and we make only one machine active at any time. So we have given the same DNS name(devqlik.xxx.client.com) to both the machines. QlikSense URL "https://devqlik.xxx.client.com/hub" or "https://devqlik.xxx.client.com/qmc" can be accessed using both the machines. Only after setting the same DNS name we are facing terrible performance issue (around 4min) accessing hub or QMC. This issue is only when the virtual proxy is used and not with the local host URL. (http://10.xx.xx.xx/hub or http://10.xx.xx.xx/qmc)

Please note we have stopped/deallocated restored machine and only DEV machine is running. Even if only one machine is running we are facing this issue. 

Please assist on how to solve this issue.

Hello,

I am running into an error when trying to store data into a QVD file - 

Attached are some screenshots with the error

"Unexpected token: 'frc_qliksensesvc', expected one of: 'qvd', 'txt', 'qvx', 'delimiter'"

Anyone have any idea what am I doing wrong?

Thanks,

Gilad

Hi experts,

Can anyone tell me how to adjust the below expression so that 'Pass' is green and 'Fail' is red?

=IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'Pass','Fail')

Thanks!

Buenas

Por favor podrían ayudarme, tengo una tabla con campo de fecha y uno de valores, lo que necesito hacer es comparar cada mes con su mes correspondiente pero en el año anterior.

Esta es la tabla que tengo, la columna que necesito agregar es COMPARACION, pero no se como hacerlo.

Si alguien tiene alguna idea se lo agradecería.

Hi Guys!

I have a SQL Server Query that works fine in SQL Management Studio. It returns a table with data.

When i use the same query in Qlik Sense it returns an error: "Connector reply error: ErrorSource: Unknown source, ErrorMsg:Unknown description".

I´m using Microsoft OLE DB Provider for SQL Server.

Attached are both codes

Please help!! Thanks in advance!

Marcos

hi collegues, I have a problem when I try to update to the version of April 2019, it does not appear the option to update, it seems like it did not detect the previous version (November 2019 patch 1),in the attachment are the images.

note: the shared folder is on another server

Hi All,

I am facing a problem with the data refresh through QMC. When I reload the dashboard manually through Qlikview it shows Correct data in all the charts. However when I refresh the dashboard through QMC the values changes drastically in all the charts. 

I have checked if any filter is being applied by refreshing through QMC, but there isn't any.

I have also removed last document state through Access point to no avail.

Can anyone help?

Hello experts, 

I have items for 3 months and they are under same "month" field but grouped by April, May, June. 

Under each month, there are managers and there are employees under each manager. 

What I'm trying to do is getting percentage that accumulates from employees to manager then to  each month. 

Eventually totaling up to 100%.  

I can get the percentage breakdown of employees, but it doesn't accumulate accordingly. Also, The table sums all the items for all 3 months and gets the percentage which give me around 30% for each month.  I want sum of total items separately so it will give me total of 100% for each month but I can't figure out how.

Here is the expression that I used 

SUM([Item1])/Sum(total<Employees, Manager>Item1)

and there is the snapshot of part of my pivot table. Thank you for your help!

Hiya, 

I'm looking to add in the script a bit to categorise as prior year vs current year. 

So all my files are labelled the same With the differences being the Month and Year. 

What I would like to be able to do is have Qliksense identify that the latest file in date is May 2019, and that is categorised as Current Year, and then have it find the one that's May 2018 and have that categorised as Prior Year so I can compare the two in multiple tables. 

I can't seem to find something a previous thread that works/gives me what I need, but I have got Qlik to recognise the May 2019 etc as a date and this is my script to do that.

Please could someone help? 

Thanks