topic Re: Display top 20 or all based when condition met(column value = some value) in QlikView

display data all based when condition met(column value = some value)

Sai78 — Wed, 16 Sep 2020 01:30:30 GMT

I'm trying to display the top 20 when user click on show top n else display all records based on condition met(column value = some value)

Attached is what I tried but logic is not working ..any insight would greatly be appreciated.

Re: Display top 20 or all based when condition met(column value = some value)

sunny_talwar — Fri, 11 Sep 2020 19:12:09 GMT

Try this

=Aggr( If(vAtt = 1, If(Rank(Only({<[column 2] = {0}, [Column 1]>} [Column 1])) <= 20, Only({<[column 2] = {0}, [Column 1]>} [Column 1])), Only({<[column 2] = {0}, [Column 1]>} [Column 1]) ) , [Column 1])

Re: Display top 20 or all based when condition met(column value = some value)

Sai78 — Wed, 16 Sep 2020 13:59:20 GMT

I tried to implement a similar approach to another condition, but I get an error in the expression,, could you check on below condition where I made a mistake or if any other way I can write this logic. (This expression has' and' and 'OR ' values )

=Aggr(
If(vPtNdAtt = 1,
If(Rank(
Only(( Status='Missing 'and DateType='CaseCreatedDate' )
OR ( [Case Type] = 'test' and testdate >='$(vToday)'and testdate<='$(v30Days)')
OR ([Case Type] = 'test2' and test2date >='$(vToday)'and test2date<='$(v30Days)' )
OR ([claims] = '0'),[Identifier]), [Identifier])) <= 20,
Only(( Status='Missing 'and DateType='CaseCreatedDate' )
OR ( [Case Type] = 'test' and testdate >='$(vToday)'and testdate<='$(v30Days)')
OR ([Case Type] = 'test2' and test2date >='$(vToday)'and test2date<='$(v30Days)' )
OR ([claims] = '0'),[Identifier]),[Identifier])),
Only(( Status='Missing 'and DateType='CaseCreatedDate' )
OR ( [Case Type] = 'test' and testdate >='$(vToday)'and testdate<='$(v30Days)')
OR ([Case Type] = 'test2' and test2date >='$(vToday)'and test2date<='$(v30Days)' )
OR ([claims] = '0'),[Identifier]), [Identifier])
), [Identifier])

Re: Display top 20 or all based when condition met(column value = some value)

Sai78 — Mon, 28 Sep 2020 05:53:31 GMT

Hi Sunny,

Could you please help me to add the OR condition to the above logic. I have a requirement to pull the data based on multiple conditions ..I tried below but not getting desired results..could you please help?