topic Re: hi,,,,about class() in QlikView

hi,,,,about class()

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: hi,,,,about class()

Anil_Babu_Samineni — Tue, 05 Dec 2017 12:29:11 GMT

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

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

Re: hi,,,,about class()

vignesh_s — Tue, 05 Dec 2017 12:55:34 GMT

but im nt geting in date formate

Re: hi,,,,about class()

Anil_Babu_Samineni — Tue, 05 Dec 2017 12:59:22 GMT

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

Re: hi,,,,about class()

vignesh_s — Tue, 05 Dec 2017 13:18:18 GMT

now im geting like dis

Re: hi,,,,about class()

Anil_Babu_Samineni — Tue, 05 Dec 2017 13:20:49 GMT

Seems, Okay. What is the wrong?

Re: hi,,,,about class()

vignesh_s — Tue, 05 Dec 2017 13:37:00 GMT

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

Re: hi,,,,about class()

Anil_Babu_Samineni — Tue, 05 Dec 2017 13:42:39 GMT

May be this?

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