topic create straight table in QlikView

create straight table

lionking15 — Wed, 25 Nov 2020 16:16:04 GMT

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!!!!!!!!

Re: create straight table

kaushiknsolanki — Mon, 01 Aug 2016 10:02:49 GMT

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

Re: create straight table

miguelbraga — Mon, 01 Aug 2016 10:03:36 GMT

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,

Re: create straight table

Anonymous — Mon, 01 Aug 2016 10:06:43 GMT

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!!

Re: create straight table

Anonymous — Mon, 01 Aug 2016 10:10:00 GMT

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!

Re: create straight table

Anil_Babu_Samineni — Mon, 01 Aug 2016 10:14:03 GMT

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)

Re: create straight table

lionking15 — Mon, 01 Aug 2016 12:21:14 GMT

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

Re: create straight table

lionking15 — Mon, 01 Aug 2016 12:21:54 GMT

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

Re: create straight table

oknotsen — Mon, 01 Aug 2016 12:33:41 GMT

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