Using a variable to set part number, Sum issue

Tue, 10 Sep 2013 09:56:47 GMT

Hi all,

Still a novice to this so this may be a very basic question.

I have set a variable as follows ,

FirstSortedValue([Part Number], -Aggr(sum({$<Week={$(=max(Week))},eTailer-={specified etailer name}>}[Total Events]),[Part Number]))

(That works fine to display the Part Number)

and referenced it in a text box to try to count the number of clicks (Total Events) this part had last week (This is for a dashboard view btw) as follows:

=sum({<[Part Number]={$(vTopPartLastWeek)}>}[Total Events])

But I cannot make this work, can anyone please tell me where I've gone wrong here?

Re: Using a variable to set part number, Sum issue

marcus_sommer — Tue, 10 Sep 2013 12:10:21 GMT

Try this:

=sum({<[Part Number]={'$(vTopPartLastWeek)'}>}[Total Events])

- Marcus

Re: Using a variable to set part number, Sum issue

Tue, 10 Sep 2013 13:16:06 GMT

Thank you SOOO much Marcus!!

This works a treat.

topic Re: Using a variable to set part number, Sum issue in QlikView

Using a variable to set part number, Sum issue

Re: Using a variable to set part number, Sum issue

Re: Using a variable to set part number, Sum issue