Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How can i use aggr in my case?
i will attach files later.
Here is attachment.
Please HELP!!!
Unfortunately the language barrier is too high my friend.
try something like below
Sum({<OrderDate={'=Date#(Aggr(Max(OrderDate),CompanyName))'}>}LineSalesAmount)
@sunny_talwar thoughts?
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.