Discussion board where members can get started with Qlik Sense.
i have a problem. I need to filtering panel by date (day/month).
add the table graphic with all fields:
id / time_table1 / desc_table1 / time_table2 / desc_table2
and need to add filtering panel by day and month. how can I solve that ?
1/3/2018 12:22:22, 2/3/2018 12:23:22, 2/3/2018 12:24:22
abc, bca, cba
1/3/2018 12:27:22, 2/3/2018 12:28:22, 2/3/2018 12:29:22
zzz, bbb, ggg
Go to Solution.
I forgot to add at the end of the script after Drop Table TempCalendar;
Drop Table QuarterNAME;
dont work for my.
the problem is :
when I select time1 it does not filter by time 2 and when filter by time 2 it does not filter by time 1.
I need a global time filter.
Because time1 and time2 are only indirectly associated by id, selecting one will not necessarily filter the other one. So your data model is not well suited to addressing your problem.
Perhaps if you could explain in more detail what your would like to achieve and upload some sample data and the required output, you might get more specific help.
try like below
id&'-'&time_table1 as %key1,
(ooxml, embedded labels, table is Sheet2);
id&'-'&time_table2 as %key2,
(ooxml, embedded labels, table is Sheet3);
time_table1 as Date,
id&'-'&Null() as %key2,
id&'-'&time_table1 as %key1
time_table2 as Date,
id&'-'&Null() as %key1,
id&'-'&time_table2 as %key2
Alternatively, you may be able to get the effect you want by using slightly more complex expressions using set analysis with the P operator. Something like this clause in the set expressions:
time1 = P(time2)
i have this:
and i need this:
Give a generic alias to the date fields
time1 as time
select * from table_1;
time2 as time
select * from table_2;
Use the calendar Master.
Date(time) AS InvoiceDate,
Year(time) AS Year,
'Q' & Ceil(Month(time) / 3) AS Quarter,
Month(time) As Month,
Day(time) As Day,
Week(time) As Week;
Load Date(MinDate + IterNo() -1 ) AS InvoiceDate While (MinDate + IterNo() - 1) <= Num(MaxDate);
Min(time) AS MinDate,
Max(time) AS MaxDate
sorry my fields :
id - primary key
time as time1
desc as desc2
time as time2
if i change time1 and time2 to ( time ) qlikSense create a synthetic relation.