Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

noobie_wiz
New Contributor III

calculated dimension using max date per constant string

I am trying to create a calculated dimension in which I need to consider (distinct max date and distinct Name_String)  to conclude output_string? Note Date is in RFC format

Name_Stringdateoutput_string
string1date1string1_yyw3
string1date3string1_yyw2
string1date3string1_yyw1
string2date1string2_yyw1
string2date3string2_yyw2
string2date3string2_yyw3

 

Output:

 

string1date3string1_yyw1
string2date3string2_yyw3
Labels (3)
2 Replies
Partner
Partner

Re: calculated dimension using max date per constant string

why do you need string1_yyw1 rather than string1_yyw2 as output for string1 ?
what does the logic behind it is ?
noobie_wiz
New Contributor III

Re: calculated dimension using max date per constant string

I need the output with respect to the constant_string and date and I need both the values as they are distinct.