topic Re: Set Analysis in QlikView

Set Analysis

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

Hi All,

in my dashboard i have data like below

STATUS	VERSION_NAME	=Count(DISTINCT(ISSUE_COUNT))
Analysis	20170224	3
Backlog	20170224	2
Backlog	-	2
Backlog	20170217	3
Development In Progress	20170224	11
Done	20170224	6
Done	R-Done	180
Gather Requirement	20170224	3
IT	-	1
IT	20170224	38
POC	20170224	2
Prod Validation	20170224	1
QA Approval	20170224	9
SA Approval	20170224	6
Tech Lead Review	20170224	3
UAT	20170224	3

if the expression as Count(DISTINCT{<VERSION_NAME= >}ISSUE_COUNT) it should not change the values according to my version_name field, in my case it is working fine but when i am giving sort condition it is not working please help me out on the same please find my sort condition as well.

If(STATUS='Backlog',1,

If (STATUS = 'Gather Requirement',2 ,

If (STATUS = 'Analysis' or STATUS='IT' or STATUS = 'POC',5 ,

If (STATUS = 'Tech Lead Review', 10 ,

If (STATUS = 'Ready for Development',15 ,

If (STATUS = 'Development In Progress',20 ,

If (STATUS = 'QA Approval' or STATUS='SA Approval',25 ,

99 //Done

)

Thanks In Advance.

Regards,

HimaBindu Ch

Re: Set Analysis

Anil_Babu_Samineni — Wed, 22 Feb 2017 10:50:56 GMT

What are the values of ISSUE_COUNT and what is the o/p

Re: Set Analysis

himabinduch — Wed, 22 Feb 2017 10:53:19 GMT

ISSUE_count has issue id please find the below

6027113
6027114
6027115
6027274
6027329
6027368
6027375
6027447
6027462
6027483
6027490
6027493
6027496
6027497
6027498
6027585
6027591
6027593
6027596
6027597

Re: Set Analysis

Anil_Babu_Samineni — Wed, 22 Feb 2017 11:54:17 GMT

What is the o/p you want to see

Re: Set Analysis

himabinduch — Wed, 22 Feb 2017 12:00:31 GMT

i want to see the count of issue_count and it shouldn't effect if i select by VERSION_NAME and i want to sort the order as based on the below condition.

If(STATUS='Backlog',1,

If (STATUS = 'Gather Requirement',2 ,

If (STATUS = 'Analysis' or STATUS='IT' or STATUS = 'POC',5 ,

If (STATUS = 'Tech Lead Review', 10 ,

If (STATUS = 'Ready for Development',15 ,

If (STATUS = 'Development In Progress',20 ,

If (STATUS = 'QA Approval' or STATUS='SA Approval',25 ,

99 //Done

)

Re: Set Analysis

sasikanth — Wed, 22 Feb 2017 12:04:03 GMT

HI,

If it for Only sort you can try INLINE Load /Match() function

in sort tab-->Expression

=Match(

STATUS,

'Backlog',

'Gather Requirement',

'Analysis',

'IT',

'POC',

'Tech Lead Review',

'Ready for Development',

'Development In Progress',

'QA Approval ',

'SA Approval')

OR Inline LOAD in script

LOAD * INLINE [

STATUS

Backlog

Gather Requirement

Analysis

POC

Tech Lead Review

Ready for Development

Development In Progress

QA Approval

SA Approval

];

Re: Set Analysis

Anil_Babu_Samineni — Wed, 22 Feb 2017 14:02:33 GMT

May be try something like below for removing selection for one Field

Count({<VERSION_NAME= ::VERSION_NAME>} DISTINCT ISSUE_COUNT)

From below expression you can try from Script level then tell me what is your intend to sort

If(STATUS='Backlog',1, If (STATUS = 'Gather Requirement',2 , If (STATUS = 'Analysis' or STATUS='IT' or STATUS = 'POC',5 , If (STATUS = 'Tech Lead Review', 10 , If (STATUS = 'Ready for Development',15 , If (STATUS = 'Development In Progress',20 , If (STATUS = 'QA Approval' or STATUS='SA Approval',25 , 99)))))))

I didn't understand this above one where you want to course this