Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Connecting two Independent tables through an expression in Qlikview FrontEnd

Hi All,

I have below two tables with the following data. And for some technical reasons these tables are not connected in the model and there is no chance to connect them also.

Table1:

 

Opp NumberSales price
2234100
5577200
6746450

Table2:

  

Old Opp NumberOld Sales price
2234500
5577700
6746850

Now i would like to display in front end like below.

  

Opp NumberSales priceOld Sales price
2234100500
5577200700
6746450850

I was trying the below expression but it working only when i select an opp number, but i wanted show them without any selections.

Dimesion :

Opp Number

Expressions:

Sales price : Sum([Sales price])

Old Sales price: Sum({1< [Old Opp Number]=p({$}[Opp Number])  >}[Old Sales price]))



Would be great if someone can help on this..

4 Replies
Highlighted
Specialist III
Specialist III

There's probably a way to do this with set analysis, but the easiest (to me) way is:

sum(if([Old Opp Number] = [Opp Number],  [Old Sales price]))

That said, I don't really recommend this approach - why not attach the old sales price to the opp number at the script level? You don't have to actually connect the tables, just bring in the one extra column using a mapping load or a join load.

Highlighted
Contributor III
Contributor III

Thanks for your Reply.

The suggestion to use if condition is not working.

We have few restrictions not add the old sales price to Table1, because old sales price is being used in other places with other dimensions. If i add old sales price to Table1, it is like having same values in two different tables. If we do not have any other solution we will think to go for this approach.

Try to change second table of field to same as first table like below

Table1:

  Load * Inline [

Opp NumberSales price
2234100
5577200
6746450

];

Join

Table2:

   Load [Ola Opp Number] as [Opp Number], [Old Sales price] Inline [

Old Opp NumberOld Sales price
2234500
5577700
6746850

];

In front end, Create straight table

Dimension - [Opp Number]

Expressions are

1) Sum([Sales Price])

2) Sum([Old Sales Price])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III
Contributor III

Thanks for your reply.

This is going to make a join between two tables on opp number, which we can't do as i was explaining above.