Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
himabinduch
Creator
Creator

Current Selection in Set Analysis

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

28 Replies
woshua5550
Creator III
Creator III

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 ?

himabinduch
Creator
Creator
Author

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

woshua5550
Creator III
Creator III

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

sasiparupudi1
Master III
Master III

PLease share a sample app

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Maybe

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

himabinduch
Creator
Creator
Author

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.

Anil_Babu_Samineni

Why not 2016 Q2 for 2016 Q3??

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
himabinduch
Creator
Creator
Author

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

Anil_Babu_Samineni

For this, Make sense to me. Perhaps this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
himabinduch
Creator
Creator
Author

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