Hi All,

I am pretty new to QlikView. I am trying to create linked objects.

I follow the Copy & Paste as a linked object procedure but when I try to open the object properties, Qlikview crashes and closes down.

Any suggestions?

Thank you in advance

carlo

Hi, 

I am attempting to use the lookup function to return a value within a table I am loading. The table is a list of securities where some have an underlying security identified with it. Since the underlying security is a security itself, I want to use the underlying security ID to lookup the name of the security where they key value is FKIDENDITYID. For example, the security name 'IBM_Bond' (fkidentityid = 21) has an underlying id = 41. The security name for fkidentityid = 41 is 'IBM'.  

However, the lookup shown below returns no data. I have tried it with and without the brackets in every combination. 

I am loading the table below via Oracle connection:

[STDB_GC_INSTRUMENT]:
LOAD
      [FKIDENTITYID],
      [FKUNDERLYINGID] AS [STDB_GC_INSTRUMENT.FKUNDERLYINGID],
      [NAME],
      Lookup('NAME','FKIDENTITYID',[FKUNDERLYINGID]) AS [STDB_GC_INSTRUMENT.UNDERLYINGNAME];
SELECT * FROM "2004"."STDB_GC_INSTRUMENT";

Any advice is greatly appreciated 

Hoping to gain some insight on best practices for performing daily backups of Qlik Sense apps. Ideally the app's are backed up without data so as to save disk space.   This seems like it might be best addressed through API but wasn't sure if there are tools or scripts already available.  

Hello all,

I have come up with a question that seems very advanced for me to do, so I am asking for your insight.

Let's say I have the following three tables : Table1, Table2, Table3

and Table1  id1  has 1:n relationship with id2 of Table 2 (so table 2 has id1_fk in it)

         Table 2 id2 has 1:n relationship with id3 of Table3 (so table 3 has id2_fk in it and also a field called size_field)

I want to create an entirely new field in Table 1 called SIZE2 that will be populated like that:

For first  batchfrom 1  to 1000 rows of table1

- check 1st id1, find the corresponding id2s

-for these id2s, find the corresponding id3s and  size_field

- sum size_fields found

-store in SIZE2 in Table1

...

- check 1000th id1, find the corresponding id2s

-for these id2s, find the corresponding id3s and  size_field

- sum size_fields found

-store in SIZE2 in Table1

Go on to second batch from row 1001 to 2000. Do again the above in loop until all rows in Table1 (id1) are finished.

Is there a way to do so?

Thanks in advance,

Ioanna

Is there a way to organize app visualizations into subfolders? i.e. instead of having 20 visualizations, can I put these into 3 or 4 folders for easier access?

appreciate your help,

Hi, I am new to the Qlik community and looking for some specific answers as I could not find them elsewhere. 

1. What exact Qlik version supports on-premise Linux installation?

2. What would be enterprise-level pricing for the above-mentioned version?

3. What is the type of license, this version affiliates to?

4. Wanted to ask an opinion about the connectivity options of Qlik to different DB like Elasticsearch, MySQL, SQL Server.

Thanks in advance..!!

Kind regards,

Prasad

Hello dears!

I'm trying to connect to a database with QvOdbcConnectorPackage (x64) in QlikView x64 and I'm getting the following error: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed.

On the other way, I can successfully connect to the same database in another notebook using the same connector in same versions mentioned above.

I've read some topics about it and I found the suggestion to force 32 bits in editor, but for this connector it 's not possible to do it.

Any suggestions?

Thank you!

Hi gurus,

I  have a group of dataset like this 

if I filter out Flag yes, it returns me data with Red, Purple and Colorful.

is there a way, at filter panel for either Attributes or Flag , to achieve a conditional filter to only have Red and Purple without colorful.

I am thinking an expression like " if Flg = Yes, only attributes =Purple and Red"

any other ways to achieve this is also welcome. 

much appreciated.