Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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
Highlighted
Creator III
Creator III

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 !

View solution in original post

7 Replies
Highlighted
Creator III
Creator III

Hi Sony,

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

Thanks,

Highlighted
Specialist III
Specialist III

Hi,

PFA.

Highlighted
Creator III
Creator III

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,

Highlighted
Specialist III
Specialist III

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

Highlighted
Creator III
Creator III

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,

Highlighted
Specialist III
Specialist III

DAte field is available in my file .

Highlighted
Creator III
Creator III

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 !

View solution in original post