Welcome to Qlik Community

Hi All,

How can we enable Export to Excel with Current Selection in QlikSense on Local and on Enterprise server.

In Qlikview same functionality was achiever by changing the below parameter in settings.ini file.

SelectionStampInBIFFExport=1

Do we have any functionality which can help turn same feature on in Qliksense.

Thanks

JD

Hi  stalwar1‌

bps‌ziadmohd1‌vvvvvvizard‌gwassenaar‌ogster1974‌robynrshields‌

I am trying to export a table to excel can we export the table along with the current selections in qliksense.

can you please help me to figure this out.

Regards,

naveen.

Hi everyone,

I have an expression with conditional background color depending on the other expressions. Everything is good there.

When i try to print that, The printed copy doesn't have the colors on it just blank cells no colors.

Exporting to excel is working fine.

Quick view of my pivot Table.

I am not able get a way around or Understand why its happening??

Any thoughts on why this is happening?

Thanks

Nithin

Hello,

We are trying to export pivot table to excel preserving layout and format (ex. color settings).

We'd like to create an extension for this because the default export only do an export data.

We also tried to use data export API but this only exports data.

We don't know how to get the measure color property of pivot table.

Someone can help us and guide us to the right direction ?

Many thanks in advance for your time.

Best regards

Andrea

Hello. How do I change the language of qlik Sense? 

I uninstalled it and installed it again but it did not give me the option to choose another language

thanks!

Dear Qlik users,

is it possible to use a function in Qlik Sense which, once I export a table to Excel, colors Excel cells?

I tried to use the color functions like blue() but the result in Excel is a text like this RGB(255,255,0).

Thank you in advance for your help.

Hi 

I am calculating employee service length which respects time dimension, so that if past date is selected in a chart, the service length is reduced accordingly for the length at that point in time.  I am currently dividing the number of days at a point in time minus hiring date by 365 in order to convert the number of days into number of years in decimal, but as the number of days in a year varies between year to year with leap year having 366 days and normal years having 365, the calculation below is not correct.  Please could you let me know an equivalent function with Yearfrac in Excel so that I can accurately calculate the employee service years? 

Thank a lot for your help.

Hi All,

I have a table where I just want that my table should only contain the ID column value in the proper structure which include first five with alphabet next three should be numeric and end with an alphabet so total length is 9, so as per below table I should only fetch the data for 4 rows (Name1,4,7 and Name10) only in a table. Please advise how to achieve this.

Thanks

Sunil Kumar