Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
Not applicable

problem with expression

hi everyone,

      i have with an expression "Cant Usuarios Acum" in a chart:

the chart is this:

CALENDARIO_DEAL_EXTERNALS.AñoMesCant. UsuariosCant Usuarios  Acum
Nov-2010408408
Dic-2010438846
Ene-201111121958
Feb-201111213079
Mar-201112744353
Abr-201134917844
May-2011470812552
Jun-2011625818810
Jul-2011793226742
Ago-20111192838670
Sep-20111027248942
Oct-20111333962281
Nov-20111361775898
Dic-20111119687094
Ene-20121130998403
Feb-20126135104538
Mar-20120104538
Abr-20120104538
May-20120104538
Jun-20120104538
Jul-20120104538
Ago-20120104538
Sep-20120104538
Oct-20120104538
Nov-20120104538
Dic-20120104538
Ene-20130104538

and this is the expression:

"=aggr( rangesum( above(

Count({<CALENDARIO_DEAL_EXTERNALS.AñoMes=>} DISTINCT DEAL_EXTERNALS.user_id)

,0,rowno()))

, CALENDARIO_DEAL_EXTERNALS.AñoMes)"

I don't know why but its generate a lot of rows with 0 values. With out that expression the chart looks well with out 0 values.

CALENDARIO_DEAL_EXTERNALS.AñoMesCant. Usuarios
Nov-2010408
Dic-2010438
Ene-20111112
Feb-20111121
Mar-20111274
Abr-20113491
May-20114708
Jun-20116258
Jul-20117932
Ago-201111928
Sep-201110272
Oct-201113339
Nov-201113617
Dic-201111196
Ene-201211309
Feb-20126135

the expresion of Cant. usuarios is:

COUNT(distinct DEAL_EXTERNALS.user_id)

thanks for any advice

gerardo

2 Replies
MVP
MVP

problem with expression

That's probably because your calendar (Calendario_DEAL_EXTERNALS.Anomes) shows all that additional values, and your expression just tells to sum all preceding months. But an additional condition could help (assuming that you get a count>0 in all passed months:

=

if(count(distinct DEAL_EXTERNALS.user_id),

aggr( rangesum( above(

Count({<CALENDARIO_DEAL_EXTERNALS.AñoMes=>} DISTINCT DEAL_EXTERNALS.user_id)

,0,rowno()))

, CALENDARIO_DEAL_EXTERNALS.AñoMes))

Not applicable

Re: problem with expression

Thank you so much swuehl!

De: swuehl

Enviado el: lunes, 20 de febrero de 2012 04:45 p.m.

Para: Pauza, Gerardo

Asunto: - Re: problem with expression

QlikCommunity <http://community.qlik.com/index.jspa>

Re: problem with expression

created by swuehl <http://community.qlik.com/people/swuehl> in New to QlikView - View the full discussion <http://community.qlik.com/message/193478#193478

Community Browser