hi all, 

I'm trying to run a SQL statement that creates a few TEMP tables and then applies some joins to those tables. 

The query runs just fine in the IDE but when running it in Qlik Sense script, the reload fails. the reason is that the query contains multiple semicolons (;), indicating the end of the SQL, or at least that's what Qlik thinks and ignoring the rest of the SQL, causing a syntax error at the reload time. 

here's a simplified version of the SQl I'm trying to run in qlik:

CREATE TEMP TABLE Eng as (

select distinct FIELD_A
from SCHEMA.fact_table

);  // first semicolon 

CREATE TEMP TABLE phone_calls as (

SELECT das.*
FROM SCHEMA.fact_table_TWO das
); // second semicolon 

select *
from Eng
left join phone_calls on phone_calls.key_field_1 = Eng.key_field_2
; // last semicolon 

thank you all!

Hi All,

In 100% stocked bar chart im getting miscellaneous bar after 100%, i have unchecked the Include null values as well for the dimensions. how to get rid of this unwanted bars. developing this chart in Qliksense

Thanks in Advance.

Hi,

I am a new user to QLIK and I want to find a way to view the source code for an app developed with the GUI interface ( creating plots, bar charts, etc)  within QLIK.

I am developing apps with QLIK desktop on secure databaseand cannot send the app  to the QLIK sense due to secuirty. I can however send text from my secure network to the network with QLIK sense. 

Would it be possible to develop an app  (using the GUI interface) with QLIK desktop, obtain the source code , and copy & paste that source code into a text file, and use that source code to generate the same APP i developed on QLIK desktop? 

Hello Qlik experts,

Is there a security rule that prohibits the user from viewing the most important factors in the QMC for certain tasks/apps etc.? For example, the user is only allowed to see a group of elements.

Best regards

Son

Hi! 

I had a few dashboards that I'd made with Personal Edition for a portfolio, and came to want to re-use them since I'm looking for work again. Unfortunately trying to open them I was just met with "Failed to open" errors. 

Hang on though! I can almost hear you linking the usual methods to fix this from here! Thank you, but none of those work! What's more, if I create a new dashboard, save it, and go to open it? I get the same issue.

I've uninstalled QV and restarted, no good. 

I've uninstalled, manually purged all instances of anything mentioning 'Qlik' from the registry, and restarted, no good.

Qlikview just doesn't seem to be able to open any files on my machine at all? What's super frustrating is that about a month ago I managed to open one of them just fine. 

Anyone got any other tips or suggestions? I'm kind of at my wit's end since I've got interviews coming up and I'm fairly sure they're going to ask me to see some of my work. Any help would be massively appreciated!

Hello All,

Can anyone please help me with the below scenario :-

This is my Data model

I want to achieve below association:-

User table linked with ID Card table on %IDCard

User table linked with Activity table on %userID

Activity table linked with ID card table on %projectID

Right now it is creating circular. Can anyone please help me to achieve this relationship by eliminating circular loop ?

Please help

Thank You

Hello Qlik Experts,

The "License Monitor" and "Operations Monitor" tasks have not been working for a few days.

When I start the load script for the "License Monitor" task manually, the following error occurs:

Does anyone knows how to solve this problem?

Best regards Son

Hi Expert

I have the data as below and is trying to compare the 2 dates using IF function. 

If Schedule End date is later than Next Due Date then it will be Miss

If Schedule End date is same or earlier than Next Due Date then it will be Done

My function is as below but have problem with same month. Please help

=If ([Schedule End Date] > [Next Due Date], 'Done', 'Miss')