topic Re: set analysis help required in QlikView

set analysis help required

Wed, 25 Nov 2020 16:16:04 GMT

the below one works

=Sum({

<[Customer Name] = {"=Sum(Sales) <= $(vSlidemax)"}>

}Sales)

in the hilighted string , i have to add this condition >=$(vSlidemin)

it means i need sum(sales) between $(vSlidemax) and $(vSlidemin)

thanks in advance

sunny_talwar — Thu, 06 Oct 2016 10:52:39 GMT

Try this:

=Sum({<[Customer Name] = {"=Sum(Sales) >= $(vSlidemin) and Sum(Sales) <= $(vSlidemax)"}>} Sales)

Anil_Babu_Samineni — Thu, 06 Oct 2016 10:53:56 GMT

Perhaps This

=Sum({<[Customer Name] = {"'>=' & $(vSlidemin) '<' & $(vSlidemin)"}>} Sales)

=Sum({<[Customer Name] = {"'>=' & '$(vSlidemin)' '<=' & '$(vSlidemin)'"}>} Sales)

Thu, 06 Oct 2016 10:55:26 GMT

it works. thank you

sunny_talwar — Thu, 06 Oct 2016 10:56:01 GMT

Anil you cannot compare Customer Name to a min and max date range my friend. This is not the right way to do it brother.

Anil_Babu_Samineni — Thu, 06 Oct 2016 10:57:03 GMT

Ok Bro, Thanks for recommend me

Thu, 06 Oct 2016 10:57:55 GMT

sorry anil.

it is not working for me

sunny_talwar — Thu, 06 Oct 2016 10:59:11 GMT

No problem