topic Re: Filter Counting Based on Month selection in QlikView

Filter Counting Based on Month selection

hammermill21 — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I have a filter that is calculating the count of inventory:

Expression: Count([Inventory Bascom Item Type])

Frequency Expression: Bascom Inspection Frequency

Month Expression: Month

And I want it to change based on a Frequency OR Month selection. SO if I select frequency "monthly" it does count only inventory that has a monthly inspection but I also want it to count if I select month Feb it counts the inventory twice, and if I select March it counts it 3 times. Can that be done?!

Thank you!!!

Re: Filter Counting Based on Month selection

sasiparupudi1 — Thu, 05 Apr 2018 14:13:25 GMT

May be like

If(frequency='Monthly,Count([Inventory Bascom Item Type])

Count([Inventory Bascom Item Type]) * Num(Month(Date#('$(vMonth)','MMM')))

)

Re: Filter Counting Based on Month selection

hammermill21 — Thu, 05 Apr 2018 14:19:58 GMT

Thanks Sasidhar but that doesn't seem to work either

Re: Filter Counting Based on Month selection

sasiparupudi1 — Thu, 05 Apr 2018 14:32:01 GMT

Have you tried the if with the expressions values related to your model?...I am guessing here

If(WildMatch([Bascom Inspection Frequency],'monthly'),Count([Inventory Bascom Item Type])

Count([Inventory Bascom Item Type]) * Num(Month(Date#([Month],'MMM')))

)

If this does not work, pl attach a sample

Re: Filter Counting Based on Month selection

hammermill21 — Thu, 05 Apr 2018 14:39:21 GMT

I think adding the "Wildcard" part works

The thing is I also need it to count based on the months that are selected. It sounds a bit complicated but when a Month is selected let say March, then I want the inventory to be counted *3 since it's three months. But if Frequency Monthly or Quarterly or Annually is selected it counts the inventory for those.

Does that make sense?

Re: Filter Counting Based on Month selection

sasiparupudi1 — Thu, 05 Apr 2018 14:48:40 GMT

try putting this in a text box

Num(Month(Date#(Max([Month]),'MMM'))) and see if you get a number

Try

If(WildMatch([Bascom Inspection Frequency],'monthly'),Count([Inventory Bascom Item Type])

Count([Inventory Bascom Item Type]) * Num(Month(Date#(Max([Month]),'MMM')))

)

If(WildMatch([Bascom Inspection Frequency],'monthly'),Count([Inventory Bascom Item Type])

Count([Inventory Bascom Item Type]) * Num(Max(Month))

)

Re: Filter Counting Based on Month selection

hammermill21 — Thu, 05 Apr 2018 14:59:46 GMT

If(WildMatch([Bascom Inspection Frequency],'monthly'),Count([Inventory Bascom Item Type])

Count([Inventory Bascom Item Type]) * Num(Max(Month))

)

That one WORKED! I would have never figured that out but I understand what you did. Thank you so much!!!!