Fixed Expressions on Chart

[ivandrago]

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

[sunny_talwar]

Not sure I understand. Can you try elaborating?

[Anonymous]

Ivan

Does the attached give you food for thought ?

[ivandrago]

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

[Anonymous]

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

[krishna_2644]

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

Is there any flag to differentiate?

[Oleg_Troyansky · Accepted solution]

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

[#8]

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

[#9]

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?

[ivandrago]

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