topic Re: Need Help Urgent Please in QlikView

Need Help Urgent Please

mshailaja — Wed, 25 Nov 2020 16:16:04 GMT

I have straight table with dimensions as ID, Product, sales

I want to hide the column ID in the straight table like below:

(Condition- I hid the column ''ID " in straight table-Presentation tab)

My requirement is I have to display all the columns and expressions in excel as below

Can anyone help?

Message was edited by: Community Moderator for spelling

Re: Need Help Urgent Please

neelamsaroha157 — Fri, 16 Sep 2016 18:08:21 GMT

Try creating two charts one with ID field and other without.

Hide the chart with the ID column.

Create a button to send to excel from this chart (hidden).

Re: Need Help Urgent Please

Jason_Michaelides — Fri, 16 Sep 2016 18:08:39 GMT

So you want to hide the ID column in QV, but when the user exports to Excel, ID should be exported too?

I'm not sure this is straight forward. You might consider a toggle button that switches between an "export-ready" chart and the "normal" chart. Button will toggle a variable to show/hide a chart with ID shown or not and Export button enabled.

It's a workaround but may suffice?

Re: Need Help Urgent Please

MK9885 — Fri, 16 Sep 2016 18:32:44 GMT

You can hide the column as shown above in the image.

Click on your ID dimension> Enable Condition>if(ID=1,1,0)

And to export to XL, if you hide the column then you cannot export that column to XL. You'll need a Button to do that.

You can customize the button and place it on chart, uncheck the XL from Caption tab in properties and replace that with this button. (As mentioned by jason.michaelides)

Users will have a full data XL file and it will save on the location you want.

Note: It will be saved as .csv file, not .xml.

Thanks.

Re: Need Help Urgent Please

viveksingh — Fri, 16 Sep 2016 18:51:16 GMT

This Cannot be achieved. if you hide the column and export the data, you cannot get the hidden column in your excel.

you have to remove your condition.

Re: Need Help Urgent Please

el_aprendiz111 — Fri, 16 Sep 2016 20:15:40 GMT

Hello

You can with a macro:

Follow the steps (to export data to Excel works well)

Re: Need Help Urgent Please

mshailaja — Tue, 27 Sep 2016 08:30:46 GMT

Thank You fer

I got the solution