Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

associate chart with filter selections;restrict tables which populates chart

Hi All,

I have a scenario where I have a number of partners and period in months.

One chart displays subscription partners and two other tables populate vod and ppv partners respectively.

Each of this has separate queries, but the alias i.e. 'Partner' is same across all.

As a result of this, the chart that is supposed to display only subscription data is displaying vod ppv partners as well,

though the expression fields are null.

This happens when i give the expression if(rowno()=0,avg(UNITARYCOST_SUBSCRIBER), sum(UNITARYCOST_SUBSCRIBER))

if i just give =sum(UNITARYCOST_SUBSCRIBER),

this problem does not arise.

Second doubt.

I have a chart with the only dimension being month.

but the data displayed varies when I make partner selections as well.This is again because all the queries share the same aliases.

Is there any way I can detach a chart from particular selections?

Thanks and Regards,

     Anju Gopinath

1 Solution

Accepted Solutions
Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

Hi All,

I found the solution to the first problem as well.

Follow these steps:

Go to

Settings ->Document Properties -> Tables----check 'Loosely Coupled' for all tables.

Regards,

Anju

8 Replies
Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

what is the data structure?

Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

Hi All,

I found the answer to the second doubt,

http://community.qlik.com/message/126780#126780

the chart has two expressions : Final & Average_Base

so for both, just add the condition:

=sum ({$<PARTNER=>}FINAL_BASE)/100000000;

=sum ({$<PARTNER=>}GVT_AVERAGE_BASE)/100000000

This will detach the chart from any selections you make for 'Partner'

Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

Hi Pari Pari,

Sorry, I didn't get your question.

-Anju

Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

I think it might be possible to solve the first issue using set analysis .

I just have to use the logic 'display values only if partners are from <tablename>'

tablename being my query table.

Can someone help me with the set analysis part, please?

Thanks and Regards,

Anju Gopinath

Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

Hi,

I am attaching the app.

-Anju

Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

i suggest you to join table1, table2, table3 into one table (with column like type containing values vod, ppv and subscriber)

Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

Hi Pari Pari,

I have NOT done a join in qlik view before. I'll try that ,

but is there any way I can achieve the same with a calculated dimension?

I tried this...

only({$<$Table={'Table1'}>}PARTNER)

it is restricting some rows, but not achieving the full result...it's showing

'error in calculated dimension'..and the partner dimension itself is not appearing?

is it possible to tweak this expression to achieve the desired result?

Here, 'table1' is the query result that I want to populate the chart with...

Thanks and Regards,

Anju Gopinath

Not applicable

Re: associate chart with filter selections;restrict tables which populates chart

Hi All,

I found the solution to the first problem as well.

Follow these steps:

Go to

Settings ->Document Properties -> Tables----check 'Loosely Coupled' for all tables.

Regards,

Anju

Community Browser