Qlik Sense do not calculate per row in table

Denis2205 — Mon, 08 Apr 2019 14:18:22 GMT

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.

Re: Qlik Sense do not calculate per row in table

fosuzuki — Tue, 09 Apr 2019 18:45:56 GMT

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...

topic Re: Qlik Sense do not calculate per row in table in App Development

Qlik Sense do not calculate per row in table

Re: Qlik Sense do not calculate per row in table