Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
what is the data structure?
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'
Hi Pari Pari,
Sorry, I didn't get your question.
-Anju
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
Hi,
I am attaching the app.
-Anju
i suggest you to join table1, table2, table3 into one table (with column like type containing values vod, ppv and subscriber)
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
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