Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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,
Go to Solution.
I found the solution to the first problem as well.
Follow these steps:
Settings ->Document Properties -> Tables----check 'Loosely Coupled' for all tables.
what is the data structure?
I found the answer to the second doubt,
the chart has two expressions : Final & Average_Base
so for both, just add the condition:
This will detach the chart from any selections you make for 'Partner'
Hi Pari Pari,
Sorry, I didn't get your question.
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?
I am attaching the app.
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...
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...