Data model issue

satishkurra — Fri, 12 Oct 2018 17:00:52 GMT

I currently has 2 tables with Revenue and Value. Both the tables contain different dimensions

Table1:

Region,

City,

Date,

Revenue

Table2:

Region,

City,

Date,

Signal Type

Value

I'm trying to either concatenate or use link table.

When i try creating a combo chart with Primary axis as Revenue and Secondary as Value based on Date, it works fine with also Region selected

The issue is if user selects from Signal Type value dimension, Revenue disappears and only displays Value. This is how the data is as we do not have signal type for Revenue.

Any thoughts to still display both Revenue and Value on Signal Type selection

Note: Layover the charts on top do not suffice my requirement.

Attaching sample data and app

Re: Data model issue

satishkurra — Fri, 12 Oct 2018 17:04:04 GMT

I changed revenue expression to Sum ({<Signal=>}Revenue). Even if user selects Signal dimension, Revenue do not change and only Value changes. This should suffice my requirement.

Any other thoughts?

topic Re: Data model issue in QlikView

Data model issue

Re: Data model issue