topic Dynamic expression in QlikView

Dynamic expression

Anonymous — Fri, 11 Apr 2014 16:41:20 GMT

Hi,

Looking for a way to create and show an expression like this = (Top N Total / All Totals)%.

Where N can be any number. I have already created a variable vTop as an input variable box.

swuehl — Fri, 11 Apr 2014 17:29:17 GMT

Maybe like this in a text box expression (assuming Top N Customer Sales, I think you need to say Top N what dimension by what measure):

= sum({<Customer = {"=rank(sum(Sales))<=vTop"}>} Sales) / sum(Sales)

or format as percentage:

=num( sum({<Customer = {"=rank(sum(Sales))<=vTop"}>} Sales) / sum(Sales),'#.00%')

Anonymous — Mon, 14 Apr 2014 11:35:53 GMT

Hi,

I realized you omitted the $ sign for the variable but when I included the expression changes with every input make in the input box.

Thanks a lot.