Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Denis2205
Contributor II
Contributor II

Qlik sense do not calculate variables in table

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.

 

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Denis2205
Contributor II
Contributor II
Author

You say that it is impossible to calculate the KPI in table?
I just wanted to show the dynamic of kpi in chart.
dplr-rn
Partner - Master III
Partner - Master III

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
Denis2205
Contributor II
Contributor II
Author

How can i use aggr in my case?

i will attach files later. 

Denis2205
Contributor II
Contributor II
Author

Here is attachment.

Please HELP!!!

dplr-rn
Partner - Master III
Partner - Master III

Unfortunately the language barrier is too high my friend.

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

 

@sunny_talwar thoughts?

Denis2205
Contributor II
Contributor II
Author

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.