topic Re: Dynamically Changes the value in Text Object in QlikView

Dynamically Changes the value in Text Object

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have created 5 Text objects with Top Categories (1,2,3,4,5) by hard coded Categories with below expression

=Num(Count({<ProblemDateType={'Opened'},Problem.dv_u_problem_category= {'Application availability'},Problem.Calendar.Year= {'2018'}>}Problem.number)/Count({<ProblemDateType= {'Opened'},Problem.Calendar.Year= {'2018'}>} Total Problem.number),'#,##0.##%')

but i am trying to get change Category name dynamically after its value get changed. plz refer below

Can any one suggest the solution.

Thanks

Rajesh

Re: Dynamically Changes the value in Text Object

sunny_talwar — Mon, 04 Jun 2018 17:27:52 GMT

May be this

=Num(

Count({<ProblemDateType = {'Opened'}, Problem.dv_u_problem_category = {"$(=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category)))"}, Problem.Calendar.Year = {'2018'}>}Problem.number)/

Count({<ProblemDateType= {'Opened'},Problem.Calendar.Year= {'2018'}>} Total Problem.number)

,'#,##0.##%')

Re: Dynamically Changes the value in Text Object

Rajesh — Mon, 04 Jun 2018 17:49:56 GMT

Hi Sunny,

Thank you for reply its seems fine but how can i get the Category names will change dynamically

and i need to show Top 2,3 ,4 & 5 in respect individual Text Objects.

Regards

Rajesh

Re: Dynamically Changes the value in Text Object

sunny_talwar — Mon, 04 Jun 2018 17:55:10 GMT

Add the 2, 3, 4, and 5 within FirstSortedValue to get 2, 3, 4 and 5th highest category

=Num(

Count({<ProblemDateType = {'Opened'}, Problem.dv_u_problem_category = {"$(=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category), 2))"}, Problem.Calendar.Year = {'2018'}>}Problem.number)/

Count({<ProblemDateType= {'Opened'},Problem.Calendar.Year= {'2018'}>} Total Problem.number)

,'#,##0.##%')

Re: Dynamically Changes the value in Text Object

Rajesh — Mon, 04 Jun 2018 18:26:54 GMT

Value is working fine Sunny,

Name also should change dynamically plz refer below one

Re: Dynamically Changes the value in Text Object

sunny_talwar — Mon, 04 Jun 2018 18:30:36 GMT

You still didn't figure out that? Really, try this

=FirstSortedValue({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.dv_u_problem_category, -Aggr(Count({<ProblemDateType = {'Opened'}, Problem.Calendar.Year = {'2018'}>} Problem.number), Problem.dv_u_problem_category))

Re: Dynamically Changes the value in Text Object

Rajesh — Mon, 04 Jun 2018 18:36:13 GMT

I tried that but there was syntax error couldnt find.

Thank you Sunny for u r help.

-Rajesh