Set Analysis

[hathwarjaya]

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]

May be this -

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

[Qrishna]

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]

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]

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