Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables in sheets.
Table A contains a date and sales by customer from System A
Table B contains a date and sales by customer from System B
I have two filter panes, one for table A and one for table B. That works fine but I want to use only one filter pane.
Also would be great to show sales by customer from both table in one table so that System A sales would have one bar and System B sales would have one bar.
@LBUSER You can concatenate your table with Flags to identify the table a and table b. Something like below
systemA_table:
LOAD Date,
Sales,
Customer,
'SystemA' as Flag
FROM systemA;
concatenate(systemA_table)
LOAD Date,
Sales,
Customer,
'SystemB' as Flag
FROM systemB;
This way you will have single filter and also have flexibility to see just for systemA or systemB data based on Flag created.
You can also use that Flag as dimension in bar chart to differentiate Sales across the system and you can also create different measure like below to have separate measure view of both system like below
=sum({<Flag={'SystemA'}>}Sales)
=sum({<Flag={'SystemB'}>}Sales)
@LBUSER You can concatenate your table with Flags to identify the table a and table b. Something like below
systemA_table:
LOAD Date,
Sales,
Customer,
'SystemA' as Flag
FROM systemA;
concatenate(systemA_table)
LOAD Date,
Sales,
Customer,
'SystemB' as Flag
FROM systemB;
This way you will have single filter and also have flexibility to see just for systemA or systemB data based on Flag created.
You can also use that Flag as dimension in bar chart to differentiate Sales across the system and you can also create different measure like below to have separate measure view of both system like below
=sum({<Flag={'SystemA'}>}Sales)
=sum({<Flag={'SystemB'}>}Sales)
@LBUSER Are you using QlikView or Sense? I'd like to move this into the correct product forum.
Im using Sense.
Thank you!