topic Pivot table value bifurcate in QlikView

Pivot table value bifurcate

prma7799 — Thu, 07 Sep 2017 09:27:12 GMT

Hi All,

I have two table with same column but different data I have achieve require output with individual pivot chart now i want to combine all these data with one pivot table.

For example :

I have table PQR and LMN in that I have location group wise data now i want to create chart like attached . I getting difficulties in that can anyone please help me out.

PFA...

Re: Pivot table value bifurcate

rohitraut — Thu, 07 Sep 2017 09:51:40 GMT

hello,

try this

First concatenate both base tables, then take a pivot table.

Re: Pivot table value bifurcate

prma7799 — Thu, 07 Sep 2017 10:06:06 GMT

Hi Rohit ,

I did the same but I am not getting separate values it is added all values into the one value

Re: Pivot table value bifurcate

shraddha_g — Thu, 07 Sep 2017 10:12:03 GMT

Link both table by field Location group and then try to create required chart.

Re: Pivot table value bifurcate

rohitraut — Thu, 07 Sep 2017 10:19:10 GMT

Can you please share the sample data?

Re: Pivot table value bifurcate

prma7799 — Thu, 07 Sep 2017 10:38:13 GMT

Hi Rohit,

I have concatenate both table with Flag am able to achieve the bifurcate but at Total level it adding all values

In the attached I getting all values as total but I want all Invoice total and for final total I want all invoice total - credit total.

Re: Pivot table value bifurcate

shraddha_g — Thu, 07 Sep 2017 10:51:35 GMT

Share sample app to help you better

Re: Pivot table value bifurcate

prma7799 — Thu, 07 Sep 2017 10:58:01 GMT

It is done by using straight table...

Thank for your reply...

Re: Pivot table value bifurcate

qliksus — Thu, 07 Sep 2017 11:29:54 GMT

Just join the two tables based on LocGroup and Currency

LOAD * INLINE [
    Loc Group, Currency, Amount (FC) ,   Amount (Rs.)
    ABC, EUR, 200.00 , 140.00
    ABC, USD, 270.00 , 183.00
    XYZ, AUD, 418.00 , 212.00
    XYZ, EUR, 940.00 , 677.00
    XYZ, GBP, 135.00 , 110.00
    XYZ, INR, -   , 407.00
    XYZ, USD, 233.00 , 158.00
];

LOAD * INLINE [

    Loc Group, Currency, Amount ,Amount1
    Less , GBP, 273.00 , 227.00
    Less , USD, 187.00 , 126.00
];

And take the below values in the chart

Dimension: Loc Group, Currency

Expression: Purgechar(sum([Amount (FC)]) - (sum(Amount)),'-')