Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find a field related to a date with the label

Please... I need Help,


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


Example:

  

SIMBOLDATE
X16-3204/08/2016
X16-3203/08/2016
X16-3202/08/2016
X16-3201/08/2016
X16-3131/07/2016
X16-3130/07/2016
X16-3129/07/2016
X16-3128/07/2016
X16-3127/07/2016
X16-3126/07/2016
X16-3125/07/2016
X16-3024/07/2016
X16-3023/07/2016
X16-3022/07/2016
X16-3021/07/2016
X16-3020/07/2016
X16-3019/07/2016
X16-3018/07/2016
X16-2917/07/2016

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


TKS

1 Solution

Accepted Solutions
geminihzh
Specialist
Specialist

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

View solution in original post

10 Replies
vamsee
Specialist
Specialist

Use the Date as Dimension

Expression:

SIMBOL*1

Not applicable
Author

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
Champion III
Champion III

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

raju_insights
Partner
Partner

Hi Rafael Oliveira,

In label just give =SIMBOL

geminihzh
Specialist
Specialist

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

Not applicable
Author

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

Not applicable
Author

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

geminihzh
Specialist
Specialist

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

View solution in original post

Not applicable
Author

Perfect Zhihong He.  You rock.

Tks so much.