I am trying to show the cumulative totals in a pivot table for the total amount of visits. 

The expression that I am currently using is this: =if(Dimensionality()=3,if(sum(dwell_time)=0,0,count(distinct {<spot_number={"=Sum(dwell_time)>0"}>} Visits)),
sum({<Visits>} TOTAL <building_name, spot_group> aggr(count(distinct {<spot_number={"=Sum(dwell_time)>0"}>} Visits), building_name, spot_group, spot_number)))

I only want to count the distinct visits if the dwell_time, which is a variable that is not being used in the pivot table, is greater than 0. However, the calculation is only correct when there is a filter and when there is no filter, the Visits is not correct. As seen the Total Visits is different for the same data set with a filter. 

Hi,

I need help to create this table in Qlik Sense. The Row A and B are coming from source, and I need to derive the row (highlighted in yellow) in Qlik using measure expression. Below the highlighted rows in yellow are the excel formula to drive the row-wise calculation.

I need to do it in the table (chart) only, not in the script. Thank you for your time and support in advanced! 

Thanks,

SK

Hello support team.

[Info]
Source DB : Db2 for z/OS
Target DB : Snowflake

[Question]
Source DB has T-DES encryption columns and User-specific cryptographic algorithm columns.
Above, when character code conversion of those columns is inability, how does Qlik Replicate behavior?

1.Skip replication of record that character code conversion is inablity.
2.Continue to replicate regardless of conversion inablity. (And output error or warning, substitute applicable data to specific character like "□")
3.Stop replication task.

Best Regards.

Column CreatorDoc is missing from XML view of QVD in Qlik Sense February 2024.

After upgrading to February 2024 Patch 3 from May 2023 Patch 6. 
We have a small issue with the upgrade, this would hinder our ability to effectively troubleshoot some of the issues:
 
In some scenarios we would need to know the name of the app that creates QVD's as we have many extract and transform app, In the previous version we had a column "CreatorDoc" under XML view of QVD, this column stores the app id of the app that created QVD. This is no longer available in the new version. Is there any workaround or options?

Hi i am trying to show annual promotion count in KPI graph. If nothing is selected, graph should show YTD stats, else the number should be updated as per the fiscal year selected.

The below code shows the YTD stats but doesn't show the stats as per filter selection:

=if(
GetSelectedCount([Promotion_dt.Fisc.Year])=0,
Count(Distinct if(Promotion_dt>=AddMonths(date(yearstart(today(),0,7)),0),Emp_No)),
count(distinct Emp_No)
)

When nothing is selected YTD, correct YTD number is returned

On filter selection, this becomes 'Zero'

The below code shows the stats as per filter selection, but count the whole employee base when nothing is selected:

=if(Promotion_dt>=AddMonths(date(yearstart(today(),0,7)),0) ,count(distinct Emp_No),count(distinct Emp_No))

Nothing selected, so number should be 160 for YTD promotions

Working fine for filter selections