Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Scripting during visualization

Hello, i am not currently allowed to manage the data loading or modeling on the application but i have to create  visualization boards  for then. The question is, i have some tables or group of tables  not  directly connected but with common fields which i´d like to use to filter data and make some drills to make the visualizations i need.

Is there a way to perform this ? Which is the best (easiest) approach? I´d be gratefull for materials related to it.

Best regards

Ticiana Justa

 

Labels (2)
2 Solutions

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

There are cases in which you could use something like this:

sum({< Table1.Field1 = p(Table2.Field2) >} AnyValue)

to connect unrelated tables. But usually those datamodels are intentionally designed to apply such a logic. If it's not the case it's rather unlikely that you could do it within the UI. Beside the permission to adjust anything within the datamodel you need to understand how it's designed and why was it created in this way. With this knowledge you will know what you could do and what not - and if it's important in any way that the datamodel must be changed from someone.

- Marcus

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

It has nothing to do with the server or any configuration - the only counting point is to have/create a proper datamodel. Some weaknesses there might be bypassed within the UI but usually the needed efforts and knowledge for it are much higher as building a normal datamodel in which all data have a proper relationship (and if you could it make work it might be quite (too) slow).

Therefore my suggestion to solve the challenges on the cause and not on the effects.

- Marcus

View solution in original post

7 Replies
Highlighted
Creator III
Creator III

From post what I can guess is you have tables but those tables are not linked but based on the tables(unlinked) you have need to create a chart, correct?

If yes, than you can create chart but that will of no use.. as data is not linked and when you filter or select the data chart will not response with proper data. 

Highlighted
Contributor II
Contributor II

Thanks
Highlighted
Creator III
Creator III

If you get the desired solution please mark the accept solution, so thread will get closed.

Highlighted
Contributor II
Contributor II

I understand  that it is problably the answer, but i´d like to let the question for a litlle more time to see if another solution is possible.

Best regards everyone!

Highlighted
MVP & Luminary
MVP & Luminary

There are cases in which you could use something like this:

sum({< Table1.Field1 = p(Table2.Field2) >} AnyValue)

to connect unrelated tables. But usually those datamodels are intentionally designed to apply such a logic. If it's not the case it's rather unlikely that you could do it within the UI. Beside the permission to adjust anything within the datamodel you need to understand how it's designed and why was it created in this way. With this knowledge you will know what you could do and what not - and if it's important in any way that the datamodel must be changed from someone.

- Marcus

View solution in original post

Highlighted
Contributor II
Contributor II

Hello Marcus,

I´ve tried  this but didn´t work .. is there any server configuration with enable this kind of feature?

Best Regards

Ticiana Justa

Highlighted
MVP & Luminary
MVP & Luminary

It has nothing to do with the server or any configuration - the only counting point is to have/create a proper datamodel. Some weaknesses there might be bypassed within the UI but usually the needed efforts and knowledge for it are much higher as building a normal datamodel in which all data have a proper relationship (and if you could it make work it might be quite (too) slow).

Therefore my suggestion to solve the challenges on the cause and not on the effects.

- Marcus

View solution in original post