Discussion Board for collaboration on QlikView Scripting.
I have a field called [Reporting Date] where it has quarter dates. I want to create 2 listboxes for this [Reporting Date] field where i want to show in First Listbox and Second Listbox:
First Listbox: just want to show current or most current quarter. With the above quarter dates, it should only show "3/31/2015"
Second Listbox: It's the opposite to the first i want to show all quarters except "3/31/2015"
I have tried "Only()" without any success. Any inputs will be greately apprecaited!
Go to Solution.
See attach. !
Use these expressions in the listboxes:
Aggr(If(InQuarter([Reporting Date], Today(), 0), [Reporting Date]), [Reporting Date])
Aggr(If(InQuarter([Reporting Date], Today(), 0), [Reporting Date]) = 0, [Reporting Date])
I tried both of your expressions in the listboxes but I couldnt get it right. can you see attached qvw to see if i missed anything? Thank You.