Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
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
jayaseelan
Creator III
Creator III

Hi Sony,

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

Thanks,

soniasweety
Master
Master
Author

Hi,

PFA.

jayaseelan
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,

soniasweety
Master
Master
Author

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

jayaseelan
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,

soniasweety
Master
Master
Author

DAte field is available in my file .

jayaseelan
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