Export dimension fields to excel

[#1]

Hi All,

I am facing a situation and need help ASAP. I am using dimensional limits in a QlikView bar chart and showing top 5. The requirement here is:

1. I still continue showing top 5 in dimension

2. When I export it to excel it should list all the dimensional values irrespective of being in top 5

3. I cannot use a macro to export

Please guide me here ASAP.

Thanks and Regards,

Vishal Dwivedi

[mohamed_ahid]

Hi,

Without macro excel , i don't know.

but ,may be you can try like in my sample file .

Regards

[marcus_sommer]

Quite often it's useful to use different objects for exports and prints (which might be on a hidden sheet) then those which will be normally used through the users. But in your case is a hiding of such a sheet not suitable - but you could also use a container which objects has only the purpose to be exported.

Another way could be that you controlled the number of to display dimension-values with a variable or a selection on a specialized field, like:

ShopTopDimensionValues:

Load * Inline [

Top

5

10

50

500

5000

];

and these selection could be caught with: $(=getfieldselections(Top)) and is used within the restriction tab.

- Marcus

[sathishkumar_go]

Hi,

Instead of dimension limits, you have change the expression like

if(rank(aggr(sum(F2),F1)) <= 3,sum(F2))

try this expression in the above attached application.

--Sathish