topic Re: Table condition in QlikView

Table condition

everest226 — Mon, 28 Nov 2016 20:23:44 GMT

I have a table. In that table I have dimensition as YEar months so i have all the months of 2016 and expression is count user.

i only want to display top value like jan and sep i have 30 value each i only want to display jan and sep data.

my expression is ( to get data from current year till last month.

Max(Aggr(Count (DISTINCT {<Year={'$(=max(Year))'}, Month-={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month),'MM')))"}>} [Authenticated user]),[Date Time]))

robert_mika‌

Re: Table condition

sunny_talwar — Mon, 28 Nov 2016 20:59:10 GMT

Would you be able to share some sample data with expected output?

Re: Table condition

everest226 — Mon, 28 Nov 2016 21:33:29 GMT

this is sample, thanks

Re: Table condition

Frank_Hartmann — Mon, 28 Nov 2016 21:46:27 GMT

see attached file.

use this as dimension:

=aggr(only({<Employee={'=rank(sum(Salary))=1'}>}Employee),Employee)

hope this helps

Re: Table condition

Frank_Hartmann — Mon, 28 Nov 2016 21:49:19 GMT

you can even use this as expression:

aggr(only({<Employee={'=rank(sum(Salary))=1'}>}Employee),Employee)

Re: Table condition

sunny_talwar — Mon, 28 Nov 2016 21:52:46 GMT

You can try this expression:

Sum({<Employee = {"=Rank(Sum(Salary)) < 2"}>}Salary)

Re: Table condition

everest226 — Mon, 28 Nov 2016 22:04:37 GMT

So this is the expression of for current year all months till last months . how do i implement your given on this expression

Max(Aggr(Count (DISTINCT {<Year={'$(=max(Year))'}, Month-={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month),'MM')))"}>} [Authenticated user]),[Date Time]))

Re: Table condition

everest226 — Mon, 28 Nov 2016 22:06:45 GMT

Thanks sunny

So this is the expression of for current year all months till last months . how do i implement your given on this expression top [Authenticated user]) ,, if [Authenticated user]) has 90 value in 3 months i want all 3

Max(Aggr(Count (DISTINCT {<Year={'$(=max(Year))'}, Month-={"$(=month(date#(max({<Year={'$(=max(Year))'}>}Month),'MM')))"}>} [Authenticated user]),[Date Time]))

Re: Table condition

sunny_talwar — Tue, 29 Nov 2016 00:11:20 GMT

I am not sure I completely understand your requirement. Would you be able to provide a sample which is more inline with your requirement and also provide some information about the expected result?

Best,

Sunny