calculated dimension

[#1]

Hi Experts,

i have to make a calculated dimension for the last (recent) 10 weeknos in pivot table.

can someone please help me with the expression

[Anil_Babu_Samineni]

May be Calculated dimension like

I assume you may have Week function like Week(DateField) as Week

If(Week <= 10, Week)

[#3]

anil,

i want to list the latest 10 weeks

[Anil_Babu_Samineni]

If possible can you please share sample

OR this for Calc. dimension as usual

If(Week >= Max(Week)-10 and Week <= Max(Week), Week)

Or this for expression

Sum({<Week = {">=$(=Max(Week)-10) <=$(=Max(Week))"}>} Sales)

[Kushal_Chawda]

It would be difficult to suggest something on this. Please provide more information. What are dimensions in pivot table and expressions in pivot table? Providing sample will give you quicker and better solution

[hic]

I would define this in the script by e.g.

If((WeekStart(Today())-WeekStart(Date))/7<10,WeekName(Date)) as WeekName,

See also

https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

HIC