topic Re: ignoring selections in set analysis in QlikView

ignoring selections in set analysis

grajmca_sgp123 — Sun, 26 Jul 2015 04:46:54 GMT

Hi,

I would like to ignore selections (made in a list box) for expressions used in my pivot table.

I used following expression in the table for Max Year:

MaxYear expr:

sum({< Year = {$(vMaxYear)},Year = ,Quarter = ,Month = >} Sales)

Previous Yearexpr:

=sum({< Year = {$(vPreYear)},Year = ,Quarter =,Month = >} Sales)

above two expr have different data for max year and previous year but I am getting same values for both years.

If we remove ignore conditions(Year =,Month 😃 the Values are correct but i am unable to ignore the selection.

i have attached one sample app for your reference.

Re: ignoring selections in set analysis

robert_mika — Sun, 26 Jul 2015 04:55:12 GMT

Try:

For all selection

MaxYear expr:

sum({1< Year = {$(vMaxYear)},Year = ,Quarter = ,Month = >} Sales)

Previous Yearexpr:

=sum({1< Year = {$(vPreYear)},Year = ,Quarter =,Month = >} Sales)

For current selection

MaxYear expr:

sum({$< Year = {$(vMaxYear)},Year = ,Quarter = ,Month = >} Sales)

Previous Yearexpr:

=sum({$< Year = {$(vPreYear)},Year = ,Quarter =,Month = >} Sales)

Re: ignoring selections in set analysis

grajmca_sgp123 — Sun, 26 Jul 2015 05:25:28 GMT

Hi Robert Thanks for your quick reply,

Have you opened my attached sample qvw,I have tried all the ways but not getting correct values.

the values are not correct here

Product	Total Sales	sum({$< Year = {2015},Year = >} Sales)	sum({$< Year = {2014},Year = >} Sales)
	385	385	385
A	385	385	385

Re: ignoring selections in set analysis

robert_mika — Sun, 26 Jul 2015 05:34:06 GMT

I'm at home using PE version.

Could you attached data set you are using?

Re: ignoring selections in set analysis

maxgro — Sun, 26 Jul 2015 06:29:48 GMT

in your expression for max year

sum({< Year = {$(vMaxYear)},Year = ,Quarter = ,Month = >} Sales)

remove Year=

the expression should be

sum({< Year = {$(vMaxYear)},Quarter = ,Month = >} Sales)

and also for previous year expression;

the result is

Re: ignoring selections in set analysis

grajmca_sgp123 — Sun, 26 Jul 2015 06:39:43 GMT

here I have attached my sample data set

Re: ignoring selections in set analysis

grajmca_sgp123 — Sun, 26 Jul 2015 06:46:12 GMT

yes Values are fine but month and Quarter selections not ignored.I am wondering why selection will work if we ignore also.

see the attachment

Product	Total Sales	sum({$< Year = {2014},Quarter = ,Month = >} Sales)	sum({$< Year = {2013},Quarter = ,Month = >} Sales)
	15	145	0
A	15	145	0

Re: ignoring selections in set analysis

maxgro — Sun, 26 Jul 2015 06:50:39 GMT

because in set analysis

Month=

is for disregard Month

but you're selecting in the

MonthID field

Month and MonthID are different fields

Re: ignoring selections in set analysis

grajmca_sgp123 — Sun, 26 Jul 2015 07:01:21 GMT

no i selected month only not monthID

Re: ignoring selections in set analysis

maxgro — Sun, 26 Jul 2015 07:18:05 GMT

if you select in Month

Jan or May or Jun or Jul

you get always the same result (240 for 2015 and 145 for 2014)

If you select in Month Feb the result change, you don'thave data for Feb in 2015 so you get 2014 for max Year (145) and 2013 (0)

The selection in Month hasn't effect on the expression, you always get all the year

If you select in MonthID the selection has effect on the expression

Do you agree?

Re: ignoring selections in set analysis

grajmca_sgp123 — Sun, 26 Jul 2015 07:28:22 GMT

Thanku,Yes I agree with you,I want to ignore selection on years also but not working??can you explain why its not possible on Year??

Re: ignoring selections in set analysis

maxgro — Sun, 26 Jul 2015 08:09:55 GMT

to ignore Year

sum({$ <Year =>} Sales)

to ignore Year and Month

sum({$ <Year=,Month=>} Sales)

if you want the total sales within the application, disregarding the selection but not the dimension

sum( {1} Sales )

or something else?

Set Analysis: syntaxes, examples