Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III
‎2016-08-01 04:20 AM

expression

Hi everyone,

could you explain to me this expression please :

Age =dayStart(Today()) - dayStart([Date création] )

I need to get the working days between date creation and today, with excluding the days on vHol variable. here's my formula :        

(NetWorkDays([ROW_ADDED_DTTM],   [ROW_LASTMANT_DTTM]-1, $(vHol))

Is my expression correcte?

Thanks

Labels (1)
Labels
651 Views
0 Likes
3 Replies
vinieme12
Champion III
Champion III
‎2016-08-01 04:32 AM

is your expression not working?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
597 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2016-08-01 04:53 AM

While you are asking about expression, Try to share whole expression with out Variables?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
597 Views
0 Likes
jonathandienst
Partner - Champion III
Partner - Champion III
‎2016-08-01 05:05 AM

Looks OK, assuming that the the 2 fields are QV date values and that vHol is defined correctly. vHol  should look like

Set vHol = '2016/01/01', '2016/05/01';

Test the expression without vHol; and if the number is correct, then add vHol and test again.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
597 Views
0 Likes