Dears,

I am making a table that contain many columns and user can select the columns they are interested in.

I separated the columns in groups, so it is easier to search for items.

The problem happened when selecting multiple items in same filter.

In pictures an example, when I select only one under Figures filter, I will get the column but if both selected, they will be hidden. 

And here after selecting both:

I am using this code for each Item in the table (Show column if):

=If(SubStringCount('Gross Premium',GetFieldSelections(_FigureField))>0,1,0)

=If(SubStringCount('Sum Insured',GetFieldSelections(_FigureField))>0,1,0)

I Appreciate any suggestions you have and if you have other way or source I can learn from.

Good day,

The previous Qlik Community thread refers: Export total straight table to Excel - Page 3 - Qlik Community - 1620552

Our company currently uses on prem QlikView and Qlik Sense, but plan to migrate to Qlik Sense SaaS in December 2024.

Currently QlikView allows one to dump a Straight Table and Pivot Table to Excel whilst retaining 1) totals and 2) column formatting (background and text colors, etc.). 

On prem Qlik Sense also allows data exports from Tables and Pivots to Excel, but without retaining totals and column formatting. This is especially frustrating for troubleshooting purposes when this said data set could potentially contain "dislocated (erroneously unlinked) dimensions" which, as underlying rows, do not technically contribute to the measure totals.

Will this oversight be fixed in Qlik Sense SaaS?

This will address quite a crucial need in my industry.

Please confirm.

Thank you kindly.

Hi 

We updated our Qlik Sense enterprise server to the Feb Tech Preview and our QSense services are not starting up.

After running the update we got the following message:

And when trying to start the repository service we get the below error:

We attempted to change the registry setting in the server and also change the location of the postgres DB and this did not fix our issue

Your assistance would be highly appreciated 

Kind regards,

Justin 

I am trying to calculate the sum of the debits for the current month using the formula below. I'm not sure what I'm doing wrong here because I get only 0s with this formula.

sum({$<GL_Month={"=$(=Date(Floor(MonthStart(Max(ActualsDate))),'MMM-YYYY'))"}>}Accounted_Debit)

I want to calculate the value for the previous month as well.

GL_Month is the month column that is derived in the script with the following formula :

Date(MonthStart("ActualsDate"), 'MMM-YYYY') as GL_Month,

Hi There,I have n number of columns in the table and I would like to apply rank function on below variables based on latest survey date where i can filter out rank = 1.

Appreciate your advice.

Something similar to SQL Query.

rank() over (partition by COUNTRY, STATE order by survery_date desc)

from table

where rank = 1

Dear All,

We have a dashboard where all these calcs which you see are KPI's. The reason to use KPI is to see the up or down arrow with color to see performance. But while we load the page, it is taking too much time. 

Please suggest what is the best way to represent same data with optimized sheet loading. 

thanks in advance.

Hi Everyone,

I have multiple KPI objects in my sheet. when I am loading this app it takes sometime to load the numbers. is there any way we can improve the loading. (Currently the data is loaded from a QVD).

thanks in advance.

Hi all,

Could you recommend me any articles or corses (now a qlikhelp), or sort of roadmap how to get these knowledge?

just read and try everything on qmc?