topic Re: hi in QlikView

hi

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

in pivot table i tried create a sum(LineSalesAmount) with dimensions 'CompanyName' and Calculated dimension i.e., =class(num(OrderDate-$(vDate)),$(varWidth),'dt') as 'Date Range' but im not geting ,i created a variable called 'vDate' and its value i given as '=Today()' and varWidth =30,i added ClaenderObject by using vDate and inputbox using varWidth, can any give solution for this

Re: hi

Gysbert_Wassenaar — Wed, 06 Dec 2017 09:17:54 GMT

First increase the width of the Date Range column in the pivot table so you can see what values are being calculated in that dimension.

Re: hi

vignesh_s — Wed, 06 Dec 2017 09:23:09 GMT

its not in date format

Re: hi

Anil_Babu_Samineni — Wed, 06 Dec 2017 09:23:29 GMT

Not sure, Why you want to create one more thread hi,,,,about class()

Re: hi

Gysbert_Wassenaar — Wed, 06 Dec 2017 09:26:33 GMT

Well, no. If you subtract two dates then you get the number of days between those dates as a result, not a date. Can you explain what you're trying to do?

Re: hi

vignesh_s — Wed, 06 Dec 2017 09:26:59 GMT

in that i not mentiond my problem clearly so i created new thread

Re: hi

vignesh_s — Wed, 06 Dec 2017 09:40:11 GMT

i was practicing an exercise in image below(2 images) about class

Re: hi

Gysbert_Wassenaar — Wed, 06 Dec 2017 09:46:07 GMT

That exercise can't be right. The class function will never give the output in the pictures on the right page.

Re: hi

vignesh_s — Wed, 06 Dec 2017 09:51:04 GMT

oh ok,thank you

what expresion should i use to get date in class function