topic Calculated Dimension in QlikView

Calculated Dimension

NickBentley — Thu, 12 Aug 2021 05:55:27 GMT

Hi All,

I am after some help with a calculated dimension.

In a straight table I want to display the name and sales qty of items that are graded as 'fast' for this week of sales only.

My dimensions are:

-Item Name

-Item Sales Speed

- Sales Week

- Sales qty

My current sales week is week 6.

Appreciate all help and suggestions.

Cheers,

Nick

lironbaram — Thu, 12 Aug 2021 07:38:20 GMT

Something like this

aggr(if([Item Sales Speed]='Fast',[Item Name] & '-' & sum([Sales qty])),[Item Name])

MayilVahanan — Thu, 12 Aug 2021 09:47:24 GMT

Try like below

Sum({<[Item Sales Speed]={'fast'}>}[Sales qty])

Based on ur week selection, it will display the sales qty with "fast" grade for the items