topic Export dimension fields to excel in QlikView

Export dimension fields to excel

Mon, 08 Feb 2016 11:26:31 GMT

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

Re: Export dimension fields to excel

mohamed_ahid — Mon, 08 Feb 2016 15:17:24 GMT

Hi,

Without macro excel , i don't know.

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

Regards

Re: Export dimension fields to excel

marcus_sommer — Mon, 08 Feb 2016 15:31:40 GMT

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

500

5000

];

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

- Marcus

Re: Export dimension fields to excel

sathishkumar_go — Mon, 08 Feb 2016 15:43:19 GMT

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