Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

warrentk80
New Contributor III

Historical trends with selected period

Good morning, I need to be in a line chart an economic course of a given period. in September analysys I set forumla = Only ({} Driven unit (If (Only (TOTAL OrdinamentoMese) = Only ({} Month), sum ({} $ {} [Engaged in €] / 1000000)), OrdinamentoMese, Month)) if no period appears the trend is not set for all months Figure 2 conversely if it imposed a month the line graph represents only an object you can represent all the values having your period? They select as October, but the line chart shows all values as if no time was set. Available for clarification Thank you Andrew

5 Replies

Re: Historical trends with selected period

Hi Andrea,

Sorry but I couldn't understood your issue.

Is it possible for you to give us some examples along with the sample data.

Regards,

Kaushik Solanki

warrentk80
New Contributor III

Re: Historical trends with selected period

attached sending the picture with what I would be

the period is selected, but the line graph represents the whole course and not only the data of the month (Figure 1)

Re: Historical trends with selected period

Hi,

Is it possible to share the expression which you have written for the chart.

Regards,

Kaushik Solanki

warrentk80
New Contributor III

Re: Historical trends with selected period

Histogram:=Aggr(num(sum ({1< Serie={'$(var_serie)'}   > } [Budget in €]/1000000 ) , '###0,0')/12*ValoreMese, DescrizioneMese)

Line Char: =Only({<Mese>}Aggr(If(Only(TOTAL <OrdinamentoMese> OrdinamentoMese) = Only({<Mese>}Mese), sum ({<Mese>}{$< AnnoSerie={'2016'} >} [Impegnato in €]/1000000 ) ), OrdinamentoMese, Mese))

Thanks


Regards


Andrea Masciulli

Re: Historical trends with selected period

Hi,

Change the expression to below.

Line Char: =Only(Aggr(If(Only(TOTAL <OrdinamentoMese> OrdinamentoMese) = Only(Mese), sum ({$< AnnoSerie={'2016'} >} [Impegnato in €]/1000000 ) ), OrdinamentoMese, Mese))

Regards,

Kaushik Solanki

Community Browser