Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everibody, i need help with.
I'm working with qlik sense server 3.0
I load data from a view on MSSQL,
this view is like this:
SEASON BRAND SOLD
2013 A 150
2014 A 200
2014 B 130
2015 A 300
2015 B 180
2015 C 130
Now i want to make an app with two filter pane for the season, one filter pane for the brand and two pivot table.
With the first season filter i want to select the season on the first pivot, with the second season i want to select the other pivot table.
I need the brand filter to select from both the pivot table.
I wrote this simple script:
[TABLE_1]:
LOAD "SEASON" AS "D_1_SEASON",
"BRAND",
"SOLD" AS "D_1_SOLD";
SQL SELECT "ST_SIGLA",
"SEASON",
"BRAND",
"SOLD"
FROM "DB".dbo."SOLD_VIEW";
[TABLE_2]:
LOAD "SEASON" AS "D_2_SEASON",
"BRAND",
"SOLD" AS "D_2_SOLD";
SQL SELECT "ST_SIGLA",
"SEASON",
"BRAND",
"SOLD"
FROM "DB".dbo."SOLD_VIEW";
The problem is that when i select only one of the season the other pivot table make a selection at the second pivot table with the brands which are present even in the first.
For example, if i chose the season 2013 for the first pivot and 2015 for the second i will be not able to see the brand B and C for the season 2015, but only the brand A because it is the only one present in the seaeson 2013.
What i need is to show all the brands for both the seasons selected and then use the brand filter pane.
What can i do to solve this problem?