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: 
Creator II
Creator II

Fixed Expressions on Chart

Hi,

I have the attached Document, is it possible to have fixed dimensions and a measure for each one?


For example there is not direct link for the Desc "Unreported" and "Other" so I am having to do a text expression, not sure if I have explained myself very well but want the "Unreported" & "Other" to be part of the Chart Straight table?

Any ideas?

Thanks

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

If I understand your problem correctly, your "Unreported" totals are signified with the flag Adj=1, while "Other" totals are signified with the flag Adj = 0.

If you don't have the corresponding Data field, you can create a synthetic dimension, using the ValueList() function, and condition your expression based on the current value of the ValueList().

Check out my new book QlikView Your Business. I'm describing in detail how to use synthetic dimensions and how to tweak the behavior of your charts to match your business needs.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

View solution in original post

20 Replies

Not sure I understand. Can you try elaborating?

Ivan

Does the attached give you food for thought ?

Creator II
Creator II

Hi Bill,

Thanks for the reply but not really what i want, I kind of want it as per my example but not sure it is possibe?

Thanks

Sorry, but I can't grasp what you are after.  Could you elaborate ?

Specialist III
Specialist III

can you explain how we could get to know what records belong to 'Unreported' and 'Other'?

Is there any flag to differentiate?

MVP & Luminary
MVP & Luminary

If I understand your problem correctly, your "Unreported" totals are signified with the flag Adj=1, while "Other" totals are signified with the flag Adj = 0.

If you don't have the corresponding Data field, you can create a synthetic dimension, using the ValueList() function, and condition your expression based on the current value of the ValueList().

Check out my new book QlikView Your Business. I'm describing in detail how to use synthetic dimensions and how to tweak the behavior of your charts to match your business needs.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

View solution in original post

Not applicable

Do you want 'Other' and 'Unreported' to be a value in the Desc dimension like Area North, Area West, Global and National

Not applicable

I do not believe we can come up with a solution ore recommendation until we know the answer to Krishna's question - how do we know what belongs in Unreported, Other?

Creator II
Creator II

I've attached another document within there I've tried to explain what I am after.