topic calculated dimension in QlikView

calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: calculated dimension

Anil_Babu_Samineni — Wed, 31 May 2017 15:53:10 GMT

May be Calculated dimension like

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

If(Week <= 10, Week)

Re: calculated dimension

Wed, 31 May 2017 16:04:01 GMT

anil,

i want to list the latest 10 weeks

Re: calculated dimension

Anil_Babu_Samineni — Wed, 31 May 2017 16:10:16 GMT

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)

Re: calculated dimension

Kushal_Chawda — Wed, 31 May 2017 17:05:19 GMT

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

Re: calculated dimension

hic — Wed, 05 Jul 2017 06:00:56 GMT

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

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