Qlik Sense do not calculate per row in table

[Denis2205]

Hello. 

I am just a beginner in Qlik Sense. 

Now i create a dashboard. 

I had created some variables:

vPeriodEnd -> max([End of Period])

vPeriodBegin -> min([Begin of Period])

So, there is selection bar of periods.

When i choose the period, for example Q3’18 and Q4’18, variables are calculated:

vPeriodEnd -> 31.12.2018

vPeriodBegin -> 01.07.2018

Also i have variables:

vClosedAtTime ->

Count({<[Question Created Date] = {“$(=‘<=’ & $(vPeriodEnd))”},

[Question Closed Date] = {“$(=‘>=’ & $(vPeriodBegin) & ‘<=’ & $(vPeriodEnd))”}

>}[Question ID])

In dashboard i want to show the KPI = ClosedAtTime

and i want to show a table with this KPI per month but it does not work  in table.  It shows the same value in each row in table.

Why QS do not calculate KPI per each row?

as you can see vPeriodBegin and vPeriodEnd are calculating, but do not take action in calculating of vClosedAtTime.

[fosuzuki · Accepted solution]

Hi Denis,

The reason is that conceptually Qlik first evaluates the Dollar Sign Expansion, generating a single Expression formula (the same exact expression for all rows), and after this, it will calculate the result for each row.

I also had trouble to understand this when I was a beginner. I hope I made it clear enough for you to understand...