Creating Dimension with respect to date values. using set analysis or calculated field.
Hi I have data in 3 tables which are associated via qlik view associative model.
I want to use the second table(group_picture) on x axis with respect to last three dates values as rank also there could be same dates repeated multiple times however i need last 3 values . Some time on very last date the picture could be empty so i need to consider the upper last three values where there is picture.
no matter if the date is same.
as per the group_name name(1st table selection) depending on the values selected as group name. If one value is selected only one project will be active in other tables group_picture and picture date.