Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of quarters and a list of the months of the year, when I select any quarter in the first list, which would automatically selects the corresponding three months of the quarter on another list, it's possible in QlikView?
hi
Qlikview automatcially select the field which is mapping to that..did quarter n month field is map to each other..if not ..try like this...
load * inline
[
quarter,month,monthkey
Q1,Jan,1
Q1,Feb,2
Q1,Mar,3
....
];
load month(DATEFIELD)*1 as monthkey,* from tablename;
Hope it helps
The structure is already that way, I would like to stay with the 3 months with green color (selected) when I choose any quarter.
add trigger for quarter ->selct in field (month)> select all possible values