Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor II

Item and Series Item

Here is part of my data model: Table1 has field Item and Sales , Table2 has field Item and SeriesItem, which represents items within the same series.

model.PNG

In the layout, I have a table chart with fields SeriesItem and Sales. Here's my question: if I select an Item, I want the table show Sales for SeriesItem.

For example, Here's the data in my model:

ex.PNG

So, when selecting Necklace, I want to see in my table chart:

222.PNG

Now in the table chart, I'm using SeriesItem as dimension, Sum({<Item={"$(=SeriesItem)"}>}Sales) as measure. But measure is only valid when one SeriesItem is selected.

How should I modify my function? Any advice helps! Thank you in advance!!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Item and Series Item

I think your current model is incorrect. You should fix it instead of mitigating the symptoms. Item in Table 1 cleary means something else then Item in Table 2. That means the Item fields should not have the same name, because if they are then you're telling Qlik Sense that they are the same, which they're not.


talk is cheap, supply exceeds demand
5 Replies
MVP & Luminary
MVP & Luminary

Re: Item and Series Item

Rename Item in Table1 to SeriesItem.


talk is cheap, supply exceeds demand
Gopi_Eswaravaka
New Contributor III

Re: Item and Series Item

It has the association so just write Sum(Sales)

it will show the sales value which you selected item.

Regards,

Gopi

wanyunyang
Contributor II

Re: Item and Series Item

Hi Gysbert, thanks for helping, but this is only a part of the original model, renaming will destroy the whole model. Is there a way to do this only in chart expression?

wanyunyang
Contributor II

Re: Item and Series Item

Hi Gopi, thanks for helping. But in this case, it can only show sales for Necklace, which is 100.

77.PNG

MVP & Luminary
MVP & Luminary

Re: Item and Series Item

I think your current model is incorrect. You should fix it instead of mitigating the symptoms. Item in Table 1 cleary means something else then Item in Table 2. That means the Item fields should not have the same name, because if they are then you're telling Qlik Sense that they are the same, which they're not.


talk is cheap, supply exceeds demand