Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ajsjoshua
Contributor III

Set analysis

Dear all,

I have a field called Login_Status

When i use it in set analysis

=Count({<Month=,YearMonth=, YearMonthKey ={"$(vMaxMonthSelect)"},Login_Status={'InProcess'}>} Distinct Login_AppNo)

it doesn't works.

But when i use it in Filter pane and select InProcess it works.

Will it be a linking issue?

Regards,

Joshua.

Tags (1)
1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Set analysis

'Inprocess' is not equal to 'InProcess'

4 Replies
jubarros
Contributor II

Re: Set analysis

Hi Joshua:

It's difficult if I can't review de qvf. Could you upload it?

The syntax seems correct.


Best Regard,

Juan P. Barroso

agigliotti
Honored Contributor II

Re: Set analysis

let's try to make it simpler as below:

first text box expression: Count( {< Login_Status = {'InProcess'} >} Distinct Login_AppNo )

second text box expression: Count( Distinct Login_AppNo )


and check if you get the same result filtering 'InProcess' as field value in both text box.

ajsjoshua
Contributor III

Re: Set analysis

Dear Andrea,

I am getting 0 for Count( {< Login_Status = {'InProcess'} >} Distinct Login_AppNo )

and for Count( Distinct Login_AppNo ) i am getting 513.

Capture1.PNG

capture2.PNG



Regards,

Joshua

agigliotti
Honored Contributor II

Re: Set analysis

'Inprocess' is not equal to 'InProcess'