Welcome to Qlik Community

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

Hi there

Just wondering if it is possible to export tables on multiple sheets in QlikSense to a single excel document with the tables appearing on separate tabs?

I know this is possible in QlikView using a macro but just wondering if it can be done with a macro or similar in QlikSense?

Thanks

Shara

Hi,

I have a requirement where we need to export multiple tables or hypercubes in QlikSense. I have tried using the Exportdata function in Table API available in Qliksense but was able to export a single table only.

Example of using exportData method

Can anyone please suggest any method to achieve this in Qliksense

Regards,

Bhargav

Bonjour la communauté,

Je souhaite avoir la visualisation suivante:

Voici mon modèle de données:

Article= 411,444,668,987 (une liste de code)

Total= '999999999'

PC=222,333,444,555,888 ( une liste de code)

date= JJ/DD/AAAA

l'idée est d'avoir la somme de créance pour les compte où le PCG=411 et ayant 

l'idée est de connaitre pour l'article 411  la répartition des sommes  pour lesquelles un PC est compris dans la liste.

Par exemple, si je prends 2 client:

Client 1 Total = 50 € et PC= 333,444,777

Client2  Total = 100 € et PC = 444,999,777

Client3 Total = 150 € et non compris dans la liste des PC

Client3 Total = 300 € et non compris dans la liste des PC

j'ai utiliser la formule suivante pour la mesure avec PC ou sans PC: 

Sum({$<article={411}>+1<PC={333,666,888}>} TOTAL) 

et article en dimension mais je n'ai pas le résultat souhaité.

avez vous des proposition.

Merci

Hi,

I am having an issue with gauge imported from Qlik Sense into Nprinting.

In QS, my gauge looks like that:

I imported it as an image but when I print it out into pdf, it does not seem to be working. The value of the measure is not shown and it looks like that:

Can anyone help me please?

Thank you.

Gerald