Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Value changes when single dimension selected

Hopefully this is a simple fix. In the attached example, my bar chart shows one value for a dimension but if I select that dimension, the value changes. The correct value is what is showing when only 1 is selected.

For example, if you select LCG Review by itself, it shows 47. This is correct. If all selections are cleared, it shows 34. That is not correct. Can't figure out why.

Thanks for your help!

Message was edited by: Cassandra Baqir Updated QVW with no hidden sheet

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

You conditionally hide sheets based on user, so when we bring up the application, all we see is a single sheet with five seemingly-useless text boxes.

Your data model seems pretty strange if you're trying to link up the process queues in both tables without actually linking the tables. I can't tell you what the right data model is, but the one you have doesn't seem to support your requirement very well.

It's hard for me to know if my chart is doing what you want or not, but this seems to produce the same results as making the selection for the few selections I made.

Dimension  = GOV_PROCESS_QUEUE
Expression = avg(if(GOV_PROCESS_QUEUE = CUR_GOV_PROCESS_QUEUE and not match(CUR_STATUS,'Closed', 'Deferred', 'Denied', 'Dismissed', 'Nursing Research & Analytics'),GOV_PROCESS_QUEUE_TAT))

View solution in original post

6 Replies
Highlighted

I believe that the attached example is not what you wanted to attach...

Highlighted
Specialist
Specialist

Yes, it is. If you select LCG Review, for example, the number goes from 34 to 47.

Highlighted
Champion III
Champion III

May be this ? Can you check?

Bar Graph expression try this?

= =AVG({< CUR_GOV_PROCESS_QUEUE = P(GOV_PROCESS_QUEUE)>} GOV_PROCESS_QUEUE_TAT)

Highlighted
Specialist
Specialist

Interesting but No, that doesn't seem to give me what I need. The chart shows the CURRENT GOV_PROCESS_QUEUE. Selecting one like LCG Review should only show data for the DEFECT_ID currently in LCG Review but with your code I get multiple. Not sure why.

Highlighted
MVP
MVP

You conditionally hide sheets based on user, so when we bring up the application, all we see is a single sheet with five seemingly-useless text boxes.

Your data model seems pretty strange if you're trying to link up the process queues in both tables without actually linking the tables. I can't tell you what the right data model is, but the one you have doesn't seem to support your requirement very well.

It's hard for me to know if my chart is doing what you want or not, but this seems to produce the same results as making the selection for the few selections I made.

Dimension  = GOV_PROCESS_QUEUE
Expression = avg(if(GOV_PROCESS_QUEUE = CUR_GOV_PROCESS_QUEUE and not match(CUR_STATUS,'Closed', 'Deferred', 'Denied', 'Dismissed', 'Nursing Research & Analytics'),GOV_PROCESS_QUEUE_TAT))

View solution in original post

Highlighted
Specialist
Specialist

Thanks, John.