topic Re: Requirement on Advanced Set Analysis in QlikView

Requirement on Advanced Set Analysis

Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Requirement on Advanced Set Analysis

sunny_talwar — Thu, 09 Jun 2016 18:33:34 GMT

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?

Re: Requirement on Advanced Set Analysis

Thu, 09 Jun 2016 18:59:49 GMT

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

Re: Requirement on Advanced Set Analysis

sunny_talwar — Thu, 09 Jun 2016 19:02:15 GMT

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

Re: Requirement on Advanced Set Analysis

sunny_talwar — Thu, 09 Jun 2016 19:25:17 GMT

Check the attached to see if this fulfills your requirement.

Best,

Sunny

Re: Requirement on Advanced Set Analysis

Thu, 09 Jun 2016 19:47:04 GMT

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)

Re: Requirement on Advanced Set Analysis

sunny_talwar — Thu, 09 Jun 2016 19:49:44 GMT

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)

Re: Requirement on Advanced Set Analysis

Mon, 13 Jun 2016 16:47:03 GMT

i have three Global filters how can i can do this

Re: Requirement on Advanced Set Analysis

sunny_talwar — Mon, 13 Jun 2016 16:55:54 GMT

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)

Re: Requirement on Advanced Set Analysis

swuehl — Mon, 13 Jun 2016 16:59:05 GMT

{<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.

Re: Requirement on Advanced Set Analysis

Mon, 13 Jun 2016 18:39:21 GMT

i am getting wrong results with that expression

Example:

1)count(DISTINCT Number) i am getting Count as150

but when i apply

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

i am getting count as 139 .

Re: Requirement on Advanced Set Analysis

sunny_talwar — Mon, 13 Jun 2016 18:41:00 GMT

Have you made selections in any of the global filters? If you have, then you see the impact of those filters filtering your data

Re: Requirement on Advanced Set Analysis

Mon, 13 Jun 2016 18:44:47 GMT

yes i made some selections on global filters and i compared with both the expressions

Re: Requirement on Advanced Set Analysis

swuehl — Mon, 13 Jun 2016 18:47:02 GMT

And besides selections in GlobalFilter1 to GlobalFilter3, do you have any other selections made in other fields, either in default or alternate states?

It would be more easy to help you if you could create a small sample (or modify Sunny's) and upload to this thread.

Re: Requirement on Advanced Set Analysis

sunny_talwar — Mon, 13 Jun 2016 18:47:14 GMT

So then isn't this what you wanted? That if you make selections in Global Filters, your expression should filter out based on whatever is not selected?

If this is not what you wanted, I think you need to provide more details here. I am not 100% sure what you are looking to do here. More information will be beneficial for us to help you out here.

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Requirement on Advanced Set Analysis

Tue, 14 Jun 2016 17:35:20 GMT

Please go through my sample document.when i apply your expressions in sample application it works fine but in my qv application

please suggest me on this

Thanks

Re: Requirement on Advanced Set Analysis

sunny_talwar — Tue, 14 Jun 2016 17:42:52 GMT

So it works in the sample, but not in your actual qvw? Is that what you mean?

Re: Requirement on Advanced Set Analysis

Tue, 14 Jun 2016 18:22:48 GMT

Yes your correct

Re: Requirement on Advanced Set Analysis

Tue, 14 Jun 2016 18:25:43 GMT

if is there any thing to change please suggest me

Re: Requirement on Advanced Set Analysis

swuehl — Tue, 14 Jun 2016 18:32:44 GMT

Hard to answer without knowing what's causing your issue or what the difference between the sample and your main application is. I would suggest that you compare your two applications and try to find the difference.

Are you using in your main application also the same fields?

I.e. you are using Country as global filter and using this as dimension in your alternate state chart?