My Qlik Sense charts don' show Full Screen option when hovered over. I read articles on how disabling touch screen solves this issue. But it does nothing to me. Any other lead would be really helpful. I created a new chart, tried both extension and native qlik charts and still no change in the behavior.

We are working on a multitenant solution and are leaning towards moving transactional db's to exadata. Currently we are on Oracle DBaaS and use Replicate to move data to Snowflake

Hi Experts,

I have the Transaction Amount as ₹72,234,435,457 . Here I want to format it as ₹72,23,44,35,457. I tried using the formatting as ₹#,#0,##0 but it is not working as expected. Could you please help here.

Thanks in advance!

I have an issue whereby an occasional UTF8 character is in a text field and this causes the whole Qlik reload to fail (bringing the data via ODBC). Is there any way to enable Qlikview to be able to handle these characters?

I've been trying to figure out this formula and I'm stuck.   

I'm pulling data in where i have a starttime and endtime which is in UTC minutes.  I need to covert that to different timezones based on each record.  Sample data below.

I need to display start and end time in hh:mm TT format.   Here is where I think I've gotten the closest one to work.  But for some reason, it's not displaying the correct AM/PM time?  

Need help identifying what I'm doing wrong.   Below is what i have in START_TIME3, which seems to be cluse, but just not exactly right.

Date(ConvertToLocalTime(Time(startMinuteOfDay/(60*24), 'hh:mm TT'),'Central Time (US & Canada)',FALSE()),'hh:mm TT')

Hi! I have an input box where a list of values can be entered, comma separated, and they are assigned to a variable. I have a button with an action to select values in a field based off that variable, and the values are =Aggr(Only({<equipment_type={$(vEquipType)}>} equipment_type), equipment_type). This is either doesn't work or selects only the first item in the list, even though the set analysis shows the whole list. Any ideas on how to get this to work? Many thanks.

We have multiple qlik replicate servers in our environment that a particular group of users have access to.  One group has access to one qlik replicate server and the other group has access to the other qlik replicate server.   However, when any of the users log in to Enterprise Manager, they are able to see all the servers and their corresponding tasks.  They can even make changes to any of the tasks on any of the servers.

How can we restrict these users to only see the server they have access to?  I noticed there is an All Servers tab in the permissions window, but if I remove users from there they cannot see anything.  Is it really an all or nothing kind of permission model?  

Thanks for any help you can provide.  

Hello,

Qlikview question: Have a stacked combo chart with Year and Category as dimensions

For 2022,

Fee (Category)= negative (-11,781)

Flow (Category)=Positive (359,661)

But the total on the top shows up as 359,661 and not 347,880 (Attached is a SS).

Any idea why? Thanks

My table is too big for one Qlik Sense dashboard to run in our production environment, therefore it needs to be split into QVD files for every two year period between 2002 and Year(Today()).

To achieve this, I am running a `for each` loop that would feed every other year value in this range into:

- a WHERE clause of the SQL query filtering by datetime (ISO8601).

- the STORE file path.

LET $(vYearList) = 2002:Year(Today();

for Each Year in $(vYearList)

LOAD STATEMENT;
SQL QUERY
WHERE datetime > ($(Year)-2)-01-01 and datetime < $(Year)-12-31
FROM DB;

Store TABLE into [lib://PATH_$(Year)_($(Year)-2).qvd](qvd);

 It would take a while to setup the reprex, but any advice on how you would write this script is appreciated, even if it's just for every year.

Hi All,

Please find the code required for this problem statement - 

App:
Load * Inline [
Id,Name
1,App Name1
2,App Name2
3,App Name3
4,App Name4
5,App Name5
];

Log:
Load * Inline [
Id,UserId
1,User1
2,User2
3,User3
4,User4
5,User5
1,User6
2,User4
3,User5
4,User2
5,User7
1,User8
2,User9
3,User4
4,User5
5,User2
];

Employee:
Load * Inline [
UserId,Desk,Role
User1,Desk1,Role1
User2,Desk2,Role2
User3,Desk3,Role3
User4,Desk4,Role4
User5,Desk5,Role5
User6,Desk3,Role6
User7,Desk4,Role7
User8,Desk8,Role3
User9,Desk2,Role4
User10,Desk10,Role10
User11,Desk3,Role11
User12,Desk4,Role12
User13,Desk13,Role13
User14,Desk14,Role3
User15,Desk15,Role4

];

Take a pivot table and use  Role and Desk and dimension while Name as a filter selection. Metric should be  - 

1. Count(distinct {<Id ={"1","2","3","4","5"}>}UserId) - this will provide the list who accessed the app

2. Count(distinct{<Name=>} UserId) - this will give all the users available 

3. If(Count(distinct {<Id ={"1","2","3","4","5"}>}UserId) =0,1) - this condition will be used to find all the desk under which none of the users had accessed the app when we select Name as a filter

when am trying aggregation on #3 above its not providing the actual count

Any help here is much appreciated.