Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

noobie_wiz
New Contributor III

Set analysis or calculated field consisting STRING field with respect to DATE

 

I am Trying to create a dimension using these fields. But i just want data for latest "n" dates.

I want to used the Table  field name on x axis with respect to last three dates per field. 

 

Dates in RFC3339  format.

Table1_Field_NAMETable2_Field_DATE
  
FIELD_A_01.1904_DB012019-01-11T03:08:07+01:00
FIELD_A_01.1904_DB032019-01-13T03:06:03+01:00
FIELD_A_01.1904_DB042019-01-14T03:09:21+01:00
FIELD_A_01.1904_DB062019-01-16T03:08:57+01:00
FIELD_A_01.1904_DB072019-01-17T03:12:40+01:00
FIELD_A_01.1905_DB012019-01-18T03:12:56+01:00
  
FIELD_B_01.1904_DB012019-01-11T03:08:07+01:00
FIELD_B_01.1904_DB032019-01-13T03:06:03+01:00
FIELD_B_01.1904_DB042019-01-14T03:09:21+01:00
FIELD_B_01.1904_DB062019-01-16T03:08:57+01:00
FIELD_B_01.1904_DB072019-01-17T03:12:40+01:00
FIELD_B_01.1905_DB012019-01-18T03:12:56+01:00

 

WhatsApp Image 2019-01-22 at 8.01.13 PM.jpeg

3 Replies
Partner
Partner

Re: Set analysis or calculated field consisting STRING field with respect to DATE

Hi,

I think below is what you want:

I think firstly you need to create a new column for group by, for example,

left(Table1_Field_NAME,10) as new_column

and then in your chart, use below expression to be dimension:

=aggr(if(rank(left(Table2_Field_DATE,10)) < 4,Table1_Field_NAME),new_column,Table2_Field_DATE)

And suppress the null value, then you can get the top 3 NAME value based on DATE like below screenshot

Set analysis or calculated field consisting STRING field with respect to DATE.PNG

Aiolos Zhao

noobie_wiz
New Contributor III

Re: Set analysis or calculated field consisting STRING field with respect to DATE

Thanks Aiolos Zhao for your valuable response.

 

I have these doubts.

Well why did you use group_by here well and also i didn't understand the reason of using 10 ??

The issue is i cant modify the load script I do not have write access  and these values are already dependent on each other so can we modify it somehow to get the desired result without changing the load script.

Highlighted
noobie_wiz
New Contributor III

Re: Set analysis or calculated field consisting STRING field with respect to DATE

Hi Aiolos,
I have edited the question with more information and explanation since you have tried to help me and spend your valuable time I want you to look at the edited question if you want to look. This is the link to it.
https://community.qlik.com/t5/QlikView-App-Development/Creating-Dimension-with-respect-to-date-value...