Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wiz_nerd
Creator
Creator

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.

 

Labels (6)
1 Solution

Accepted Solutions
uacg0009
Partner - Specialist
Partner - Specialist

Hi,

Please see my attachment.

I filled the values for projectname column, but if it's wrong, please tell me when you create the table like me, what kind of values you see.

Aiolos Zhao

View solution in original post

3 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi,

I have seen your data, it's a good news that you have the "table1" column,

but I saw that in project_name2, there are some rows that have same values in project_snap and snap_date column.

so I think you must have another column like "id" to distinguish these value,

otherwise, qlikview won't show these values in different rows, could you please tell me the column “id” name in your data model?

so I will try to find a method to solve it?

Aiolos Zhao

uacg0009
Partner - Specialist
Partner - Specialist

Hi,

Please see my attachment.

I filled the values for projectname column, but if it's wrong, please tell me when you create the table like me, what kind of values you see.

Aiolos Zhao

wiz_nerd
Creator
Creator
Author

Great effort, works perfectly 🙂

Thanks Aiolos.