topic Re: Current Selection in Set Analysis in QlikView

Current Selection in Set Analysis

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

Hi,

how can i exclude current selection in set analysis for example if i have 2017Q1 data if i select this it should show only 2016Q1 and 2016Q2 it shouldn't show 2017Q1. my expresiion is as below

=if(YearQuarter = '2017Q1',

count({<YearQuarter={'2016Q1'},YearQuarter={'2016Q2'} >} ITEM))

please help me

Re: Current Selection in Set Analysis

devarasu07 — Wed, 15 Nov 2017 03:17:28 GMT

Hi,

try like this,

=if(YearQuarter='2017Q1', count({$<YearQuarter={'2016Q1','2016Q2'}>} ITEM))

you using same field in filter selection and set analysis expression so set analysis ignore selection (to exclude single field in set analysis like this fieldname= or using the identifier as 1) won't work. you can use your count if method like above.

Thanks,Deva

Re: Current Selection in Set Analysis

Anil_Babu_Samineni — Wed, 15 Nov 2017 03:36:06 GMT

You expression seems okay to me, Are you facing any issue over subtotal? If so, Try this?

=Sum(Aggr(if(YearQuarter = '2017Q1', count({<YearQuarter={'2016Q1'},YearQuarter={'2016Q2'} >} ITEM)),YearQuarter))

If you want to exclude only current selection which is one

count({<YearQuarter -= {"=GetFieldSelections(YearQuarter)"}>} ITEM)

If you are selecting 2 or more then this

count({<YearQuarter -= {$(Concat(Chr(39) & GetFieldSelections(YearQuarter) & Chr(39), ',')}>} ITEM)

Re: Current Selection in Set Analysis

woshua5550 — Wed, 15 Nov 2017 03:47:13 GMT

try this

Count({<YearQuarter=e(YearQuarter)>} ITEM)

Re: Current Selection in Set Analysis

himabinduch — Wed, 15 Nov 2017 08:15:52 GMT

Hi Deva,

i tried but it is showing current selection as well for example if i clicked on 2017Q1 it should show only 2016Q3 and 2016Q2 it shouldn't show 2017 Q1 data.

thanks,

hima

Re: Current Selection in Set Analysis

himabinduch — Wed, 15 Nov 2017 08:19:07 GMT

Hi Dave,

its excluding all the values for my case i need to exclude only current selection.

Re: Current Selection in Set Analysis

effinty2112 — Wed, 15 Nov 2017 08:23:00 GMT

Hi Hima,

Try

count({1-$}ITEM)

Cheers

Andrew

Re: Current Selection in Set Analysis

woshua5550 — Wed, 15 Nov 2017 08:24:46 GMT

then you need add "1" as identifier

try

Count({1<YearQuarter=e(YearQuarter)>} ITEM)

Re: Current Selection in Set Analysis

himabinduch — Wed, 15 Nov 2017 08:50:08 GMT

Hey Andrew,

its working but its giving entire data set . i have 5 quarter's of data like 2017Q1,2016Q4, 2016 Q3, 2016 Q2, 2016 Q1

if i select 2017Q1 data it should show only 2016Q4 AND 2016Q3 if i select 2016Q3 i need only 2016 Q1 like this i need

please help me on this.

Re: Current Selection in Set Analysis

himabinduch — Mon, 20 Nov 2017 06:51:33 GMT

Hi Dave,

i have 5 quarter's of data like 2017Q1,2016Q4, 2016 Q3, 2016 Q2, 2016 Q1

if i select 2017Q1 data it should show only 2016Q4 AND 2016Q3 if i select 2016Q3 i need only 2016 Q1 like this i need i dont need to show selected yera quarter data

please help me on this.

Re: Current Selection in Set Analysis

woshua5550 — Mon, 20 Nov 2017 07:24:35 GMT

Hi Hima

your logic is a little bit weird ..

when you select 2017Q1 , you want to sum data from 2016Q3 to 2016Q4 ?

and when you select 2016Q3 , you want only data from 2016Q1 ?

what data do you want to show when you select 2016Q1 or 2016Q2 ?

Re: Current Selection in Set Analysis

himabinduch — Mon, 20 Nov 2017 07:34:57 GMT

Hi Dave,

i want count of created Items and shipped items,if i clicked on 2017Q1 then i need previous year And Quarter Data.

i have below fields

Created date,

shipped date

Item

Re: Current Selection in Set Analysis

woshua5550 — Mon, 20 Nov 2017 08:28:32 GMT

not quite clear about your requirement, hope this counld help you

Re: Current Selection in Set Analysis

sasiparupudi1 — Mon, 20 Nov 2017 13:33:48 GMT

PLease share a sample app

Re: Current Selection in Set Analysis

Peter_Cammaert — Mon, 20 Nov 2017 16:38:21 GMT

Maybe

=Count({<YearQuarter = -YearQuarter>} ITEM)

Re: Current Selection in Set Analysis

himabinduch — Thu, 23 Nov 2017 07:11:39 GMT

Hi Anil,

i i have 5 quarter's of data like 2017Q1,2016Q4, 2016 Q3, 2016 Q2, 2016 Q1

if i select 2017Q1 data it should show only 2016Q4 AND 2016Q3 if i select 2016Q3 i need only 2016 Q1 like this i need and i dont want to show the selected year.

please help me on this.

Current Selection in Set Analysis

Re: Current Selection in Set Analysis

Anil_Babu_Samineni — Thu, 23 Nov 2017 07:34:42 GMT

Why not 2016 Q2 for 2016 Q3??

Re: Current Selection in Set Analysis

himabinduch — Thu, 23 Nov 2017 07:38:06 GMT

the requirement is like that if the user select 2017Q1 he want to see only 2016Q4 and 2016Q3 if user select 2017Q2 he want see 2017Q1 2016Q4 2016Q3

Re: Current Selection in Set Analysis

Anil_Babu_Samineni — Thu, 23 Nov 2017 07:40:52 GMT

For this, Make sense to me. Perhaps this?

count({<YearQuarter -= {">=$(=Max(YearQuarter-3)) <$(=Max(YearQuarter))"}>} ITEM)

Re: Current Selection in Set Analysis

himabinduch — Thu, 23 Nov 2017 08:34:08 GMT

No anil its not working can u try with count({1-$}ITEM) it is displaying all Quarter's Except current selection. but i dont need entaire set