Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

RE:Daily

Hi all,

I want to show the reports for monthly and weekly and daily.  in bar chart  for last 12months,last 12 weeks, and last 12 days.

how can I achieve this?

means  X-axis   I want to show 

jan,feb...

wk01 ,w2,w3

01-jan-2016 like that

can anyone give advice on this?

sample is attached.

1 Solution

Accepted Solutions
jayaseelan
Contributor III

Re: RE:Daily

Yes Yes Date field is available in Test.xls File,

Use the Following Expressions in bar chart,


For Last 12 Months:

Sum({<Date={">=$(=Date(Addmonths(Max(Date),-12)))<=$(=Date(Max(Date)))"} >}sales)


For Last 12 Weeks:

Sum({<Week = {"<=$(=(Max(Week)))>=$(=(Max(Week) - 11))"}>} sales)


For Last 12 Days:

Sum({< [Date]=,  [Date] = {"<=$(=( date(Max(Date))))>=$(=( date(Max(Date) - 11)))"}>} sales)

I have attached you Sample application !

7 Replies
jayaseelan
Contributor III

Re: RE:Daily

Hi Sony,

       I can solve your problem please attach the DATA Test.xlsx file.

Thanks,

soniasweety
Contributor III

Re: RE:Daily

Hi,

PFA.

jayaseelan
Contributor III

Re: RE:Daily

Hi Sony,

  To achieve this task you need following extension (which i have attached)for selection the x Axis Dimensions..

Please find tha sample.qvf file..

  hope this will use full for you..

  Thanks,

soniasweety
Contributor III

Re: RE:Daily

but I don't want to use Extension... I need to show separate charts.

jayaseelan
Contributor III

Re: RE:Daily

Hi,

    Yes can do that, you need an expression fro last 12 months, Last 12 weeks and last 12 days??

     For last 12 Days you must need date Field, In your data field is not available.

Thanks,

soniasweety
Contributor III

Re: RE:Daily

DAte field is available in my file .

jayaseelan
Contributor III

Re: RE:Daily

Yes Yes Date field is available in Test.xls File,

Use the Following Expressions in bar chart,


For Last 12 Months:

Sum({<Date={">=$(=Date(Addmonths(Max(Date),-12)))<=$(=Date(Max(Date)))"} >}sales)


For Last 12 Weeks:

Sum({<Week = {"<=$(=(Max(Week)))>=$(=(Max(Week) - 11))"}>} sales)


For Last 12 Days:

Sum({< [Date]=,  [Date] = {"<=$(=( date(Max(Date))))>=$(=( date(Max(Date) - 11)))"}>} sales)

I have attached you Sample application !

Community Browser