Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this -
count({<Date= {">=$(=MonthStart(AddMonths(Today(), -13)))"}>}Ticket)
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.
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
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