topic Re: Select just one field in dimension in QlikView

Select just one field in dimension

Thu, 29 Aug 2013 15:39:44 GMT

How do I go about summing just one field within a dimension?

For example, in the dimension "Channel", I have a list of media channels. I'd like to sum up where Channel is just "PPC". How would I do that?

With thanks,

Simon

Clever_Anjos — Thu, 29 Aug 2013 15:41:12 GMT

Sum({<Channel={"PPC"}>} yourfield)

MayilVahanan — Thu, 29 Aug 2013 15:41:59 GMT

Try like this

Sum({<Channel={'PPC'}>} yourfield)

Edit:

Ex:

Sum({<Channel={'PPC'}>} Sales)

If more than two,

Sum({<Channel={'PPC','TCS'}>} Sales)

Hope it helps

CELAMBARASAN — Thu, 29 Aug 2013 15:43:57 GMT

Use set analysis which will override the selection of the field

Sum({<Channel={'PPC'}>} FieldName)

Hope it helps