topic Re: Formula is not working....need help.. in QlikView

Formula is not working....need help..

Wed, 05 Sep 2012 08:23:14 GMT

Hello every one,

I need your help here.... i have a very small formula sum({<[Contra Type]={Revenue},Quarter={$(vQuarterComparison)}>}Total)

which is troubling me...vQuarterComparison is a Variable which picks same quarter in the prev Year(=left(Quarter,3)&''&num(right(Quarter,2)-1,00))..

Please help me out and let me know why the above formula is not working..

Thanks & Regards,

Venkat T

whiteline — Wed, 05 Sep 2012 08:28:37 GMT

try

sum({<[Contra Type]={Revenue},Quarter={=$(vQuarterComparison)}>}Total)

sum({<[Contra Type]={Revenue},Quarter={"=$(vQuarterComparison)"}>}Total)

jvitantonio — Wed, 05 Sep 2012 08:33:43 GMT

I would try

sum({<[Contra Type]={Revenue},Quarter={$(=vQuarterComparison)}>}Total)

sum({<[Contra Type]={Revenue},Quarter={"$(=vQuarterComparison)"}>}Total)

Miguel_Angel_Baeyens — Wed, 05 Sep 2012 08:35:39 GMT

Hi Venkat,

Note that both right parts in your set analysis are texts, so you will need to wrap them by single quotes:

Sum({< [Contra Type] = {'Revenue'}, Quarter = {'$(vQuarterComparison)'} >} Total)

You can find more on how to use quotes in set analysis in this post.

Hope that helps.

Miguel

Wed, 05 Sep 2012 12:16:54 GMT

Thankyou so much to all of you..my issue is resolved...

Thanks & Regards,

Venkat T