topic Re: Creating Dimension with respect to date values. using set analysis or calculated field. in QlikView

Creating Dimension with respect to date values. using set analysis or calculated field.

wiz_nerd — Sat, 16 Nov 2024 04:40:46 GMT

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.

Re: Creating Dimension with respect to date values. using set analysis or calculated field.

uacg0009 — Thu, 24 Jan 2019 02:44:07 GMT

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

Re: Creating Dimension with respect to date values. using set analysis or calculated field.

uacg0009 — Thu, 24 Jan 2019 07:14:12 GMT

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

Re: Creating Dimension with respect to date values. using set analysis or calculated field.

wiz_nerd — Thu, 24 Jan 2019 07:31:24 GMT

Great effort, works perfectly 🙂

Thanks Aiolos.