Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Dynamically Changes the value in Text Object

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

Capture.PNG

Can any one suggest the solution.

Thanks

Rajesh

1 Solution

Accepted Solutions
Highlighted

Re: Dynamically Changes the value in Text Object

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.##%')

View solution in original post

6 Replies
Highlighted

Re: Dynamically Changes the value in Text Object

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.##%')

View solution in original post

Highlighted
Creator II
Creator II

Re: Dynamically Changes the value in Text Object

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

Highlighted

Re: Dynamically Changes the value in Text Object

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.##%')

Highlighted
Creator II
Creator II

Re: Dynamically Changes the value in Text Object

Value is working fine Sunny,

Name also should change dynamically plz refer below one

Capture.PNG

Highlighted

Re: Dynamically Changes the value in Text Object

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


=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)

Highlighted
Creator II
Creator II

Re: Dynamically Changes the value in Text Object

I tried that but there was syntax error couldnt find.

Thank you Sunny for u r help.

-Rajesh