Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
cpiocpio
Partner - Creator
Partner - Creator

Use of Set Analysis, Month Function In Straight Table

Used the well known wizard to create the set analy

// ---------------------------------------------------------------------

// Calculate the Sum of "calDueDate"

// based on all values

// ~~

// but before calculating

//      - Select records in field "Month(calDueDate)" matching the condition: [equal to "Month(Today())"]

// ~~~~

// Created by http://tools.qlikblog.at/SetAnalysisWizard/

// ---------------------------------------------------------------------

=Sum({1<Month(calDueDate)={$(=Month(Today()))}>}calDueDate)

However using in my chart does not return any data

Other values in use in the same chart work but I am specifying the item in those case for example :

Sum({1 <DueDateFinYear = {'2012/13'}>} i_lifts)      ----  Different field of course

1 Reply
cpiocpio
Partner - Creator
Partner - Creator
Author

IGNORE THIS POST, I duplicated posting