Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Requirement on Advanced Set Analysis

Hi

I have 6 Objects in my dashboard

i.e

2 list boxs ,LH01,LH02(Global Objects):if we select these two List boxes then only complete dashboard Has to Reflect.

4 Charts,CH01,CH02,CH03,CHO4

1)if we select CH01 then That CH01 Chart only Reflect not other charts (CH02,CH03,CH04)

2)if we select CH02 then That CH02 Chart only Reflect not other charts( CH01,CH03,CH04)

3)if we select CH03 then That CH03 Chart only Reflect not other charts (CH02,CH01,CH04)

e.t.c

Dimesion is Month field

My expressions are

1)count(DISTINCT Number)

2)(count({<resolved_Date={'=resolved_Date<=duedate3'}>}DISTINCT Incident_Number3))/count({<resolved_Date={"*"},duedate3={"*"}>}distinct Number3)


Thanks,

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

1) Count(DISTINCT {<GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} Number)

2) (Count({<resolved_Date = {'=resolved_Date<=duedate3'}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Incident_Number3))/Count({<resolved_Date={"*"}, duedate3={"*"}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Number3)

View solution in original post

23 Replies
sunny_talwar

1)if we select CH01 then That CH01 Chart only Reflect not other charts (CH02,CH03,CH04)

2)if we select CH02 then That CH02 Chart only Reflect not other charts( CH01,CH03,CH04)

3)if we select CH03 then That CH03 Chart only Reflect not other charts (CH02,CH01,CH04)

Where are you selecting CH01, CH02 and CH03 getting selected?

Not applicable
Author

i am selecting on Bars Month Wise ..

example:

i have 6 maonths Jan ,Feb,March,April,May,June.

If i selcet May then May data i can see on Bar chart.But that should not reflect on other charts Like CH01,CH02,etc

sunny_talwar

May be use three different alternate states to do this. Do you have a sample where this can be demonstrated?

sunny_talwar

Check the attached to see if this fulfills your requirement.

Best,

Sunny

Not applicable
Author

your correct sunny but

i have expressions like this who to write for this

1)count(DISTINCT Number)

2)(count({<resolved_Date={'=resolved_Date<=duedate3'}>}DISTINCT Incident_Number3))/count({<resolved_Date={"*"},duedate3={"*"}>}distinct Number3)


sunny_talwar

May be like this:

1) Count(DISTINCT {<GlobalFilter = $::GlobalFilter>} Number)

2) (Count({<resolved_Date = {'=resolved_Date<=duedate3'}, GlobalFilter = $::GlobalFilter>} DISTINCT Incident_Number3))/Count({<resolved_Date={"*"}, duedate3={"*"}, GlobalFilter = $::GlobalFilter>} DISTINCT Number3)

Not applicable
Author

i have three Global filters how can i can do this

sunny_talwar

May be like this:

1) Count(DISTINCT {<GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} Number)

2) (Count({<resolved_Date = {'=resolved_Date<=duedate3'}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Incident_Number3))/Count({<resolved_Date={"*"}, duedate3={"*"}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Number3)

swuehl
MVP
MVP

{<GlobalFilter1 = $::GlobalFilter1,GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>}

assuming your global filter are like three list boxes in default state, replace GlobalFilter1 etc. with the field names used in these list boxes.