topic Date in Chart in QlikView

Date in Chart

Mon, 12 Mar 2012 08:50:29 GMT

Hi Experts,

Can anyone help me with the below query.

I have Reporting Period in X axis and sale of mangos in Y axis.

I have 6 monthend data in the Reporting Period (eg: 201201,201112,201111,201110,201109,201108 {in YYYYMM format})

If I put the dates in a list box and select any particular date (for some other reason) , the graph is showing only that date which is very obvious!

I want the graph to show data for all the dates together even if i have selected any single date from the listbox.

Also please note I have defined 6 variables for the last 6 month end dates i.e

Var1 = 201201

Var2 = 201112

Var3 = 201111

Var4 = 201110

Var6 = 201109

Var6 = 201108

How to do it?

Pls help !

Thanks

Paul

Date in Chart

CELAMBARASAN — Mon, 12 Mar 2012 08:59:04 GMT

Hi,

Can you post your expression?

To exclude selection in particular field

Sum({<DateField=>} Sales) This will exclude the selection in DateField in box.

Celambarasan

Date in Chart

Mon, 12 Mar 2012 09:01:43 GMT

You can try set analysis

your expression will be something like

=sum({<[Reporting Period]=>} saleofmangos)

which will ignore any selection made to reporting period

Date in Chart

Mon, 12 Mar 2012 09:21:15 GMT

Hi Gopal,

in the set analysis given by you what should I mention in "[Reporting Period] = ?? "

Hi Celambarasan,

In the expression I have 'saleofmangoes' .

Date in Chart

CELAMBARASAN — Mon, 12 Mar 2012 09:23:45 GMT

Hi,

Don't mention anything leave simply as it is.

=sum({<[Reporting Period]=>} saleofmangoes)

How you calculating for 6 months?

Celambarasan

Date in Chart

Mon, 12 Mar 2012 09:43:01 GMT

Hi Celambarasan,

The above set is not working

I am not calculating anything by any formulae. The sale of Mango data is readily avalable in the excel tht i have loaded in Qlikview.

The data in excel looks like this :

Country	Reporting preiod	Sale of Mangoes
Australia	201201	51
Australia	201112	62
Australia	201111	89
Australia	201110	99
Australia	201109	223
Australia	201108	112
Australia	201201	211
Australia	201112	59
Australia	201111	63
Australia	201110	65
Australia	201109	84
Australia	201108	57
China	201201	25
China	201112	64
China	201111	74
China	201110	85
China	201109	21
China	201108	35
China	201201	45
China	201112	53
China	201111	59
China	201110	87
China	201109	65
China	201108	84

Now I want show this data in graph in such a way that even if I select a single date in qlikview my graph will still show data for the last 6 months ( that is from 201201 to 201108)

Hope I can make you understand my requirement.

Thanks

Paul

Date in Chart

Mon, 12 Mar 2012 09:50:02 GMT

Keep Country & [Reporting preiod] in dimesion and expression as

=sum({<[Reporting preiod]=>} [Sale of Mangoes])

Date in Chart

CELAMBARASAN — Mon, 12 Mar 2012 10:53:28 GMT

Hi,

Then how your are displaying six months period?

Celambarasan