Find a field related to a date with the label

[#1]

Please... I need Help,

I need to show on a label a reference to a date field ( without counting , just show )

Example:

SIMBOL	DATE
X16-32	04/08/2016
X16-32	03/08/2016
X16-32	02/08/2016
X16-32	01/08/2016
X16-31	31/07/2016
X16-31	30/07/2016
X16-31	29/07/2016
X16-31	28/07/2016
X16-31	27/07/2016
X16-31	26/07/2016
X16-31	25/07/2016
X16-30	24/07/2016
X16-30	23/07/2016
X16-30	22/07/2016
X16-30	21/07/2016
X16-30	20/07/2016
X16-30	19/07/2016
X16-30	18/07/2016
X16-29	17/07/2016

If the user selects the date 20/07/2016 should show in the label x16-30.

TKS

[vamsee]

Use the Date as Dimension

Expression:

SIMBOL*1

[#3]

Sorry,

I believe it has not been clear. The labels will show the value for the simbol field, but can be a chosen or calculated date. Basically as an Excel VLOOKUP .

Need for example, on another label which show SIMBOL the previous week chosen , then it would be a SET ANALYSIS with DATE -7 and showing the corresponding SIMBOL field.

[vishsaggi]

Where exactly you are trying to show the Label on ? Check this if this what you are looking for?

[raju_insights]

Hi Rafael Oliveira,

In label just give =SIMBOL

[Anonymous]

Hi, Rafael,

For the "label", do you mean the "label" be used as the replaced name for the dimensions or expressions? Because when you mention the "label", people will think about this, which makes your question confusing.  And I guess it is not the "lable" you mean.  It is better that you  provide a .qvw file to describe your requirement.

Zhihong

[#7]

Hi Rangaraju,

     Perfect, but I need more..

How to put a text object with a title, and another with an expression.
Even taking the current SIMBOL the SIMBOL the previous week and the previous year as well.
If one set analysis solve , but in this case no need to calculate only show the value .

example:

= ' Week sales ' & [ SIMBOL ]
= ' Week sales ' & [ simbol when data = today - seven days ]

= ' Week sales ' & [ simbol when the same day last year. ]

Tks

[#8]

I mean " text object ." Problems with the translator. (Sorry )

[Anonymous · Accepted solution]

Hi, Rafael

You can add the title by: properties->Caption tab->Check the "Show Caption".

The expression you can use is to get the SIMBOL:

for 7 days ago:

=MAXSTRING( {<DATE = {"$(=Date(today()-7,'DD/MM/YYYY'))"}>}SIMBOL)

for 1 year ago:

=MAXSTRING( {<DATE = {"$(=Date(AddYears(today()-1,-1), 'DD/MM/YYYY'))"}>}SIMBOL)

Pls notice that a function needed when you use set-analytics to get the value you want, that is why I use a MAXSTRING() here, but it will not effect your result as your case, each DATE only have one SIMBOL.

Zhihong

[#10]

Perfect Zhihong He.  You rock.

Tks so much.