Listbox and Table chart

Tue, 07 May 2013 13:04:54 GMT

I have 3 tables- 2 dimension(SG and Seg) and 1 fact table(fact).

'SG' and 'Seg' tables are related to each other via the column(SegmentGroupName) and 'Seg' and 'Fact' are related to each other via column (PrescriberId).

Now there's a listbox with values from the column SegmentGroupName of 'SG' table.

Now I want a table chart with the dimension corresponding to my selection in the listbox and the expression as Sum(TRx).-- TRx is a column in Fact table.

When i should select any value from the SegmentGroupName listbox (which is a column from 'SG' table )corresponding segments(column SegmentDisplayName) from the 'Seg' table should be displayed in the tablechart.

Is there a way to achieve this?

Also please do not post .qvw files as I have a personal edition.

Table Structures-

Table Name- Columns

SG- SegmentGroupName

Seg- SegmentGroupName, SegmentDisplayName, PrescriberId

Fact- PrescriberId, TRx.

Re: Listbox and Table chart

Gysbert_Wassenaar — Tue, 07 May 2013 14:53:54 GMT

Create a straight table with SegmentDisplayName as dimension and sum(Trx) as expression. When you select a value in the SegmentGroupName listbox the straight table will show the SegmentDisplayName values for the selected SegmentGroupName

topic Re: Listbox and Table chart in QlikView

Listbox and Table chart

Re: Listbox and Table chart