Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamic Selection in Straight table

I have two tables in my Data model as

Product IDProduct Name20012002
1Car30004000

Product IDJan 2001Jan 2002
1800900

Since Product ID is the common field. Both are connected. This is it from the Data model.

Now, I have two straight tables in UI.

1st Straight Table:

Dimension - Product ID,Product Name

Expression - 2001,2002 (No functions, just used the field names in expression)

2nd Straight Table:

Dimension - Product ID

Expression - Jan 2001, Jan 2002

Since Jan 2001 is a subset of 2001, I need to show just Product ID and Jan 2001 when the user clicks 2001. Similarly for 2002.

Say, when the user click 2001 in the 1st straight table, I should get

Product IDJan 2001
1800

Can someone tell me, how to do this? Guess it's similar to Ad-hoc Reporting. But not sure how to proceed with this.

2 Replies
swuehl
MVP
MVP

Maybe you can achieve something like you want using triggers, but I would consider changing the data model, so that the month / year relation is associative.

Maybe using a fact table with mixed granularity:

Fact Table with Mixed Granularity

Then, using a calendar that is linked to the mixed granular time dimension, and selecting Year, you should get both tables filtered accordingly.

Anonymous
Not applicable
Author

Hi,

I actually used Year and Month just for namesake. Please consider the one in 1st table as Category and 2nd table as Sub category.

How to do this with triggers?