display dimension values regardless of current selection

[ali_hijazi]

I got a pivot table in which the dimension is a column from a parent table and the expressions are from the child table

not all the columns of the parent table have related values in the child table (per year)

what I want is display all existing values of the dimension column even if there is no data in the child table

kind of a left join but without really making a left join

is this possible?

[#2]

Sorry, Your question is not very clear, though i`ll try to give my suggeston based on my assumtion.

Are you using the field for aggregation from child table? like sum(Sales), is this sales fields is from Cjild table?

Try Unchecking the "Suppress Zero Values" check box in presentation tab of the pivot table.

Please let us know if this doesnt help you.

-Sridhar

[ali_hijazi]

no this is not the case

I have 3 tables

Parent, Sub-Parent, and child

what I'm getting now in the pivot table is the following

suppose in parent I have parent 1, and parent 2

in sub-parent I have sub-parent1 and sub-parent2 and each have parent 1 and parent 2 respectively as parent!!

now in the child table if there is no data for sub parent 2 I'm not getting on pivot table neither parent2 nor sub parent 2 (as values)

what I want is show all parents and sub-parents despite the existence of related records in child or not

[erichshiino]

Is

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

the same question?

Does the answer there solve the problem(s) ?