Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

STDEV on columns

I have in a pivottabel a few columns

First:

sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum01)},Kalender_Maand={$(vMaandPeildatum01)}>} Leveren.Artikel3)

second

sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum02)},Kalender_Maand={$(vMaandPeildatum02)}>} Leveren.Artikel3)

now i wanna have a formula STDEV on the values of those columns. The formula

stdev(

sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum01)},Kalender_Maand={$(vMaandPeildatum01)}>} Leveren.Artikel3) +

sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum02)},Kalender_Maand={$(vMaandPeildatum02)}>} Leveren.Artikel3)

)

doe snot work. Anybody know what kind of formula i need?

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

RangeStdev(

     sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum01)},Kalender_Maand={$(vMaandPeildatum01)}>} Leveren.Artikel3) ,

     sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum02)},Kalender_Maand={$(vMaandPeildatum02)}>} Leveren.Artikel3)

)

View solution in original post

1 Reply
Highlighted
Employee
Employee

RangeStdev(

     sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum01)},Kalender_Maand={$(vMaandPeildatum01)}>} Leveren.Artikel3) ,

     sum( {$<Besteladvies.Jaar = {$(vJaarPeildatum02)},Kalender_Maand={$(vMaandPeildatum02)}>} Leveren.Artikel3)

)

View solution in original post