Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
herard_bertrand
Partner - Creator
Partner - Creator

A little challenge for hard core app developers ^^

Hello,

I'm working on an app, in which I need to show which boots can be set up on which Ski
(there is an example attached to play with). 
Here is the simplified model

herard_bertrand_1-1747064407585.png

Here is table of the app : 
(Boots, Ski, a simple calculation to explicit if there is a match or not) and Ski_season is a filter

herard_bertrand_2-1747064452741.png

When I click on a value on Ski_season here is the actual displays (I understand Why) : 

herard_bertrand_3-1747064770190.png

 

So my aim is to have the following behaviour : 
When I select the Tyre Season, I'd like to still sees every Boots_Name in the table (in this example 4 lines), and if the ski_name is excluded by a ski_season selection, to see a null value in the Ski_name column and the value Unmatch in the calculation ? Is it possible ?


Constraints : 
- We can't modify the link table to add lines to specify that there are no match between ski and boots. (That is to say, the link table cannot be a cartesian product between Boots and Ski with a flag indicating is there is a match or not) (because of the size of the true application=> performance issue). 
- We cannot put the ski_season field in the link_table.(because in reality there are much more fields an values in the true application => performance issue).

Infos:  
- In the link table : every Boots is in the link Table, not every Ski
- If a Boots have no corresponding Ski => a line with the Boots_ID and null value for Ski_ID exists in the Link_Table.

 

There is an example attached 


Best regards

Labels (3)
1 Solution

Accepted Solutions
herard_bertrand
Partner - Creator
Partner - Creator
Author

Thanks, 

"It looks like your biggest problem is how to show all Boots, no matter what was selected - right?" 

=> That's exactly the point.

I tried the solution on your bolg link and it works for my mini example,

Now I'm going to try it on the true huge complex model 🙂 

View solution in original post

3 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there!

It looks like your biggest problem is how to show all Boots, no matter what was selected - right?

See if this blog post can give you some ideas:

https://www.naturalsynergies.com/q-tip-20-showing-all-values-in-qlik-sense/

 

herard_bertrand
Partner - Creator
Partner - Creator
Author

Thanks, 

"It looks like your biggest problem is how to show all Boots, no matter what was selected - right?" 

=> That's exactly the point.

I tried the solution on your bolg link and it works for my mini example,

Now I'm going to try it on the true huge complex model 🙂 

marcus_sommer

Especially if it's a huge data-set and there are already issues with the performance it might be worth to rethink the data-model approach and not using a link-table else a star-scheme data-model - even more if the link-table isn't capable to resolve the missing key-stuff.

Beside this the populating of missing data does not mandatory mean to keep a cartesian data-set from any to everything else quite often it could be reduced to the essential data and are not so heavy as all the workaround-stuff of link-tables and calculated dimensions ...