Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

data interpretation problem

hi guys, i am very new to qlik sense and have a problem with my data interpretation in creating a weekly forecast in sense?

when i edit, Bar chart, add dimension,Deal - Deal created, add dimension, i get no weekly option

i cant change the data export to exclude the time,

IS THERE A OTHER WAY?

THANK YOU

 

Deal - Deal created
2017-03-03 00:12:18
2017-03-02 23:00:50
2017-02-28 08:13:26
2017-02-24 08:42:50
2017-02-24 08:39:13
2017-02-23 23:19:21
2017-02-19 10:55:19

2017-01-30 11:48:14

2 Replies
omarbensalem
Esteemed Contributor

Re: data interpretation problem

You want your x-axis to be weeks?

Deal is a column?

1)like this ? 2017-03-03

or

2) Deal-Deal created 2017-03-02 23:00:50 is a column?

Try this:

as a dimension :

1) week(date# (Deal,(YYYY-MM-DD))

2)week(timestam# (Deal,(YYYY-MM-DD hh;mm:ss))

vlad_komarov
Valued Contributor III

Re: data interpretation problem

Hennie,


There are few options how you can do that.

If I understood you correctly, you will need to have a report based on Weekly dimension.

One of the options: Create a new field from your "Deal Date" field as Week() function, for example

Week([Deal created]) as Weekly_Deal_Created_Dim


Use the same Expression (sum(Deal_Count), or else... ) and use the Weekly_Deal_Created_Dim as your chart's dimension.


So this approach requires extra steps, but it's reliable and very good performance-wise.


If script modification is not applicable in your case, use a Week([Deal created]) as Calculated dimension in your chart.

Should work fine too, but chart's performance will not be as good as with the approach above.


Regards,

Vlad



P.S. When applicable, please mark this answer Correct or Helpful.