topic Re: Two Tables with Current Selection with only one selection different in QlikView

Two Tables with Current Selection with only one selection different

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I need two tables to show data from current selection and the same table. The first table has to show the values from the "Real" income and the second one from the budget income.

I need to show the data "As Is", i.e. not the sum or something like.

RealBudget	Amount	Date	Center
Real	5000	01-02-2016	123
Real	500	02-02-2016	125
Real	300	03-02-2016	123
Real	200	04-02-2016	126
Budget	6000	01-02-2016	123
Budget	600	02-02-2016	125
Budget	350	03-02-2016	123
Budget	250	04-02-2016	126

Any idea how to do this? I actually can show the info but in the same table.. but how can I split the data in two tables Real/Budget?

Thanks!!

Re: Two Tables with Current Selection with only one selection different

sunny_talwar — Mon, 09 Jan 2017 15:38:41 GMT

May be using set analysis within a straight table? Which object are you trying to this today?

Re: Two Tables with Current Selection with only one selection different

girirajsinh — Mon, 09 Jan 2017 15:49:19 GMT

You may do something like this in straight table

and hide the expression

Re: Two Tables with Current Selection with only one selection different

cristian_av — Mon, 09 Jan 2017 15:50:40 GMT

It worked! Thanks!

Re: Two Tables with Current Selection with only one selection different

sarafamiglietti — Mon, 09 Jan 2017 15:57:14 GMT

Hello,

Please find attached a way to solve the problem.

You just have to create 2 graph "Table".

Put Realbudget, Date and Center as Dimension and in the expression you have to use a "if".

-> For real : if(RealBudget = 'Real',sum(Amount))

-> For budget : if(RealBudget = 'Budget',sum(Amount))

Regards

Sara