hi,,,,about class()

[vignesh_s]

=class(num(OrderDate-$(Vartoday)),$(varWidth),'dt')     can any one explain this

[Anil_Babu_Samineni · Accepted solution]

Read this? http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ConditionalFunctions/cl...

In your case,

class(expression, interval [ , label [ , offset ]])

(Order-$(Vartoday)) // It calculates the difference b/w two dates. And $(varWidth) // It is the interval where comes from variable. dt is the calculation between the ranges.

Note - If you look, Help you may understand each

[vignesh_s]

but im nt geting in date formate

[Anil_Babu_Samineni]

Can you show full cell rather hash code. And What if we remove dt in your statement?

[vignesh_s]

now im geting like dis

[Anil_Babu_Samineni]

Seems, Okay. What is the wrong?

[vignesh_s]

in field date range im geting value instead of 'date'

[Anil_Babu_Samineni]

May be this?

class(Date(OrderDate-$(Vartoday)),$(varWidth),'dt')