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

associate chart with filter selections;restrict tables which populates chart

Fri, 30 Nov 2012 10:12:13 GMT

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

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

Fri, 30 Nov 2012 10:26:04 GMT

what is the data structure?

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

Fri, 30 Nov 2012 10:27:10 GMT

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'

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

Fri, 30 Nov 2012 10:31:27 GMT

Hi Pari Pari,

Sorry, I didn't get your question.

-Anju

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

Fri, 30 Nov 2012 10:56:15 GMT

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

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

Fri, 30 Nov 2012 11:03:39 GMT

Hi,

I am attaching the app.

-Anju

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

Fri, 30 Nov 2012 11:46:54 GMT

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

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

Fri, 30 Nov 2012 12:11:38 GMT

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

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

Fri, 30 Nov 2012 12:48:19 GMT

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