Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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,

23 Replies
Not applicable
Author

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 .

sunny_talwar

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

Not applicable
Author

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

swuehl
MVP
MVP

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.

sunny_talwar

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

Not applicable
Author

Hi

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

sunny_talwar

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

Not applicable
Author

Yes your correct

Not applicable
Author

if is there any thing to change please suggest me

swuehl
MVP
MVP

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?