Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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

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

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

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

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

Check the attached to see if this fulfills your requirement.

Best,

Sunny

Not applicable

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)


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

i have three Global filters how can i can do this

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

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.