Qlikview - show all data from excel

[Anonymous]

Hi all,

i have excel file with two table.

I write in script code like this

  Data:

CrossTable(Location, Quantity)

LOAD Reason,

    LocA,

    LocB,

  DateM

FROM

(ooxml, embedded labels, table is Table1);

LOAD Location,

    Re as Reason,

    Answer,

    Date

FROM

(ooxml, embedded labels, table is Table2);

And I get table

and when select in Reason Total i got empty table

The first table is ok when i choose R1,R2... but how to chenge code when press Total in Reason to get all Location and it's data depending on date. Something like this (if choose Reason Total and Date 08-05-17)

Any idea?

[Anonymous]

It's not well connected.

For LocA  and R1 i have only answer  Yes and value 5. ... but I got to many combination...

[Anonymous]

I add this in second table  Re as Reason and worrk,

THAKS A LOT!!!

[Kushal_Chawda]

my mistake

Data:

CrossTable(Location,Quantity,2)

LOAD Reason, 

     Reason as ReasonFilter,

     DateM as Date,

     LocA,

     LocB

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Table1, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Total')))

));

Left Join(Data)

LOAD Location,

     Re as Reason,

     Answer,

     Date

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Table2);

Concatenate(Data)

LOAD  Reason,

      Location,

      Quantity,

     'Total' as ReasonFilter,

      Date,

     Answer

Resident Data;

[Kushal_Chawda]

Great