Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

noobie_wiz
New Contributor III

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.

 

1 Solution

Accepted Solutions
Partner
Partner

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

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

3 Replies
Partner
Partner

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

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

Partner
Partner

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

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

noobie_wiz
New Contributor III

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

Great effort, works perfectly 🙂

Thanks Aiolos.