Hi all,

I created a table in QlikSense and use its hypercube to render it in a mashup.

I would like to add the sort functionality, so that if I click on the measure header it sort the table.

I tried with "setOptions()" and "backendApi.applyPatches()" but I do not seem to be able to make it work.

Can you help me?

I wonder who designed the system 😫, which displays internal database codes instead of user-friendly information. Very poor implementation of messages

Hi guys,

I have this issue that I have tried to resolve myself for a week or two where the values of my straight tables are rendering in reports under the 'General' format instead of what I have chosen. I have posted some screenshots to help explain:

1. The qvw with the correct number format (some other tables will need to be a % or have different decimals). I have tried formatting in the expression itself as a workaround but it did not work. I can't select 'Keep source formatting' for this project.

2.  The structure of the Template. You can see the cell is formatted to number. The table will expand across 5 cells and each is formatted to replicate how it is seen in the qvw. Each row will be a different table.

3. The result. It has ignored the formatting of the expression and the template editor and reverted to 'General'.

I have browsed before posting this question but I could not see a resolution, there were some considered solved but it was for QlikSense, and one post assumed that this problem would be fixed in a newer version of NPrinting (I started this project in NP 16.7 and continued it in the Feb 2020 version).

It might not mean much but I did a direct export from the table in the qvw to an excel file just in case the server settings was overruling it and it was matching the qvw.

Need some advice on how best to set up data loading for my app. I have 2 Excel files that are generated each day. One is a list of patients seen in the ED. The other is a list of floors where patients are admitted to. Each report has an ID number that is unique to the ED visit.

When I first set up the app, I loaded patient list data for several days from an XLS file that had multiple tabs. Since then I've just been loading the new daily file. Everything seems to be working smoothly.

My original plan was to just keep loading the new daily reports. I ran into trouble when I tried to do a left join in order to add the admission location to the patient list data. Is it better to set up an association based on the unique identifier field? Is there a better way to accomplish this?

Thanks–

I want to know how to work in Qlik Business with the Widgets that I developed in the DeskTop version. How can I copy the widgets to my space in Qlik Business cloud?
How do you do this?

I read many other posts, but I can't apply it to my case...

I think "firstsortedvalue" might be the solution.

Here's my Data (I gave my best to get a good example):

What do I want to do:

There are multiple same values for "Calc. Direct Savings CHF", but I only want to see the "Vendor Category", based/ranked on the <highest> "Invoice Amount CHF" per "Direct Savings Year"

Example:

#1, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2019 is higher than #2

#3, "Vendor Category" <R> would be shown, because the "Invoice Amount CHF" for 2018 is higher than #4

Finally, out of the 4 lines, only 2 shall remain --> #1 & #3

hope this makes sense!

Thanks already 🙂

Boa noite comunidade,

preciso de uma ajuda no seguinte cenário.

Tenho um filtro MesAno: MM/YYYY

Tenho uma tabela com valores e datas, preciso montar gráfico de linhas, onde a dimensão será o dia de cada data.

E as medidas serão: sum(valor) em cima do filtro selecionado e também preciso de uma medida do sum(Valor) dos dias do Mês anterior.

Como resultado o gráfico terá duas linhas, um somatórios dos valores do mes selecionado e outro do mês anterior ao selecionado..

Como posso fazer isso?