create straight table

[lionking15]

hi

i am having a table consist of fields Customer,sales id,sales,ShipDate,product,quantity and i have linked ShipDate to master calender.

and the issue is that i have to create

straight table having below expressions

Current Year Sales,  Previous Year Sales, Current Month Sales, Previous month Sales and product as dimension

thanks!!!!!!!!

[kaushiknsolanki]

Hi,

You need to take help of the set analysis to achieve this.

Have a look at the link below for more info on how to find the current year and previous year sales.

Set Analysis for certain Point in Time

Regards,

Kaushik Solanki

[miguelbraga]

To do this you need to add a Calculated Dimension. Here are some hints on how to achieve this:

Calculated Dimensions

YTQ, QTD, MTD and WTD

Year-over-Year Comparisons

YTD and MTD Calculation in Qlikview - YouTube

Hope this might help you

Regards,

MB

[Anonymous]

Hi

Try this: Current Year Sales

Sum({<Year=, Quarter=, Month=, ShipDate={'>=$(=YearStart(Today()))<=$(=Today())'}>} Sales )

Previous Year:

Sum({<Year=, Quarter=, Month=,  ShipDate={'>=$(=YearStart(Today(), -1))<=$(=Today())'}>} Sales )

Hope it helps!!

[Anonymous]

Hi

For Current Month:

Sum({<Year=, Quarter=, Month=, ShipDate={'>=$(=MonthStart(Today()))<=$(=Today())'}>} Sales)

Previous Month:

Sum({<Year=, Quarter=, Month=,  ShipDate={'>=$(=MonthStart(Today(), -1))<=$(=Today())'}>} Sales )

Hope it helps!

[Anil_Babu_Samineni]

Current Year Sales

Sum({<Year = {Max(Year(ShipDate))}>}Sales)

Previous Year Sales

Sum({<Year = {Max(Year(ShipDate)-1)}>}Sales)

Current Month Sales

Sum({<Month = {Max(Month(ShipDate))}>}Sales)

Previous Month Sales

Sum({<Month = {Max(Month(ShipDate)-1)}>}Sales)

[lionking15]

what is wrong in this syntax: Sum({$-1<Year={year(today())}>}total_sales)

[lionking15]

what is wrong in this syntax: Sum({$-1<Year={year(today())}>}total_sales)

[oknotsen]

Should most likely be this:

Sum({$-1<Year={$(=year(today()))}>}total_sales)

So what you missed was the dollar sign expansion.

Dollar-sign expansions ‒ Qlik Sense