topic Re: Two Tables with dimensions in the same table in App Development

Two Tables with dimensions in the same table

Mon, 27 Jun 2016 07:59:44 GMT

Hey,

in my QlikSense app I have two pie charts which access the table "Tags". These tags have different topics, so I created multiple charts with tag dimensions. An object can have more than one tag in the data model.

My problem is, that when I select a filter in one of the two Tag-Pie-Charts, the other chart gets grey and says there are only objects with none of the other tags. I checked it in my data and there are objects that have two different tags. (Example screenshots are attached)

How can I archieve that the pie charts show the correct data, even though a "Tag" filter is selected?

Re: Two Tables with dimensions in the same table

Mon, 27 Jun 2016 10:20:08 GMT

Hi Lucas,

Can you share a sample qvf file.

Re: Two Tables with dimensions in the same table

Mon, 27 Jun 2016 10:51:39 GMT

This is what the (relevant) data looks like. Is this what you are looking for?

Re: Two Tables with dimensions in the same table

danansell42 — Mon, 27 Jun 2016 11:11:41 GMT

Hi Lucas,

If i understand correctly what you want....

you could apply set analysis in the expression to ignore the 'Tags' field.

for example:

sum( {<[Tags]=>} UNITS)

Hope this helps

Dan

Re: Two Tables with dimensions in the same table

Mon, 27 Jun 2016 12:53:06 GMT

I used Count(AppName) to simply count all Objects.

Count({<[Tags]=>} AppName)

does not make Qliksense ignore other tag selections, the problems is still there.

Is my formula wrong?

Re: Two Tables with dimensions in the same table

Mon, 27 Jun 2016 13:01:34 GMT

Had a typo in it, works now..

Though that is not exactly what I wanted. The tag selection should not be ignored completely in the pie charts.

I want a set analysis to work normally (I choose a category in the one pie chart and the other adapts). I would really appreciate if you could help me with this.

Re: Two Tables with dimensions in the same table

danansell42 — Mon, 27 Jun 2016 14:34:36 GMT

Would be beneficial if you have a sample app to share so i can fully understand the context of what you need.