topic Re: Count expression to compare quarter by quarter in QlikView

Count expression to compare quarter by quarter

jim_chan — Sat, 21 Jan 2017 14:31:30 GMT

Based on this script,

I am able to get new item id of current year compare to last year.

=Count(DISTINCT {<item_id = e({<item_id = {"=Count({1<batch_year = {'<$(=Max(batch_year))'}>} item_id) > 0"}>})>} item_id)

What to change if i want compare it instead of by year , compare it by quarterly. ?

1st , I select year 2016, then I select 2nd half,

When I click on the 2nd half, it will compare with 1st quarter.it will compare any new item ID in the 2nd half compare to 1st half.

I have the field called - batch_type : with data 1ST HALF , 2ND HALF. can max(batch_type) , but is not a number.

Rgds

Jim

vinieme12 — Sat, 21 Jan 2017 15:22:11 GMT

Can you post some screenshots of what you want to achieve?? and sample data??

rubenmarin — Sat, 21 Jan 2017 18:11:59 GMT

If the only values are '1ST HALF' and '2ND HALF' you can use MaxString() to get the last value sorted alphabetically.