topic Re: Set Analysis in QlikView

Set Analysis

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

Hello,

I am new to qlikview .

I want to write the following expression in set analysis.

count(if(monthname(Date)>=Monthname(AddMonths(Date(Today()), -13) ) ,Ticket))

Please help me with this.

Thanks & Regards,

Jaya

Digvijay_Singh — Fri, 16 Mar 2018 18:11:37 GMT

May be this -

count({<Date= {">=$(=MonthStart(AddMonths(Today(), -13)))"}>}Ticket)

Qrishna — Sat, 17 Mar 2018 04:06:04 GMT

Hi - in your COUNT expression you are using an expression for a field name, so,you can write a set expression something like this -

COUNT ( {$ < $(=monthname(Date)) = {'$(=Monthname(AddMonths(Date(Today()), -13) ) )'} >} Ticket )

if you are looking for a 'count' of 'Ticket' where Month name of a 'Date' equals Month Name of 'AddMonths(Date(Today()), -13) )' date

Hope that helps.

hathwarjaya — Mon, 19 Mar 2018 06:55:54 GMT

hello Digvijay,

Thanks for helping.

I am want to show the count of tickets in a bar chart for last 13 months ignoring the selections.

Please let me know the expression you have provided would give me that.

Regards,

Jaya

hathwarjaya — Mon, 19 Mar 2018 06:56:24 GMT

Hello Krishna,

Thanks for your reply.

I am want to show the count of tickets in a bar chart for last 13 months ignoring the selections.

Please let me know the expression you have provided would give me that.

Regards,

Jaya