topic Re: Qlik sense do not calculate variables in table in App Development

Qlik sense do not calculate variables in table

Denis2205 — Mon, 08 Apr 2019 14:32:43 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 variables in table

dplr-rn — Mon, 08 Apr 2019 14:40:18 GMT

set analysis is not calculated per row but only once for the entire table.
basically your expression will return for date periods which would appear if you put the variables vPeriodBegin, vPeriodEnd outside in a text object

Re: Qlik sense do not calculate variables in table

Denis2205 — Mon, 08 Apr 2019 14:44:13 GMT

You say that it is impossible to calculate the KPI in table?
I just wanted to show the dynamic of kpi in chart.

Re: Qlik sense do not calculate variables in table

dplr-rn — Mon, 08 Apr 2019 14:52:07 GMT

it can be dynamic as you show in a text object.
In a table or other charts (where you need a different range for each row.)it would need other techniques like an aggr function or similar.
share a sample app and a excel/pic of what your desired output is

Re: Qlik sense do not calculate variables in table

Denis2205 — Mon, 08 Apr 2019 15:01:41 GMT

How can i use aggr in my case?

i will attach files later.

Re: Qlik sense do not calculate variables in table

Denis2205 — Tue, 09 Apr 2019 07:46:33 GMT

Here is attachment.

Please HELP!!!

Re: Qlik sense do not calculate variables in table

dplr-rn — Tue, 09 Apr 2019 13:21:01 GMT

Unfortunately the language barrier is too high my friend.

try something like below
Sum({<OrderDate={'=Date#(Aggr(Max(OrderDate),CompanyName))'}>}LineSalesAmount)

@sunny_talwar thoughts?

Re: Qlik sense do not calculate variables in table

Denis2205 — Tue, 09 Apr 2019 14:10:05 GMT

Ok, understood.

I will try, thanks.

Here is my new post https://community.qlik.com/t5/New-to-Qlik-Sense/Creating-Calendar/m-p/1566879#M132185, if you can answer, please.