topic Re: Fixed Expressions on Chart in QlikView

Fixed Expressions on Chart

ivandrago — Fri, 16 Oct 2015 16:25:39 GMT

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

Re: Fixed Expressions on Chart

sunny_talwar — Fri, 16 Oct 2015 16:27:34 GMT

Not sure I understand. Can you try elaborating?

Re: Fixed Expressions on Chart

Anonymous — Fri, 16 Oct 2015 16:44:50 GMT

Ivan

Does the attached give you food for thought ?

Re: Fixed Expressions on Chart

ivandrago — Fri, 16 Oct 2015 17:32:09 GMT

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

Re: Fixed Expressions on Chart

Anonymous — Fri, 16 Oct 2015 17:39:38 GMT

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

Re: Fixed Expressions on Chart

Qrishna — Fri, 16 Oct 2015 17:41:45 GMT

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

Is there any flag to differentiate?

Re: Fixed Expressions on Chart

Oleg_Troyansky — Fri, 16 Oct 2015 17:50:08 GMT

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

Re: Fixed Expressions on Chart

Fri, 16 Oct 2015 18:10:52 GMT

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

Re: Fixed Expressions on Chart

Fri, 16 Oct 2015 18:45:22 GMT

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?

Re: Fixed Expressions on Chart

ivandrago — Sun, 18 Oct 2015 22:35:19 GMT

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

Re: Fixed Expressions on Chart

ivandrago — Mon, 19 Oct 2015 12:16:44 GMT

Anyone?

Re: Fixed Expressions on Chart

Mon, 19 Oct 2015 12:26:49 GMT

It looks like you want unreported and Other to be valid descr values. And the criteria for determining is in the descriptions you have on the right?

Re: Fixed Expressions on Chart

Mon, 19 Oct 2015 12:31:29 GMT

The values 'DP',NDP' are for the field DFlag?

Re: Fixed Expressions on Chart

ivandrago — Mon, 19 Oct 2015 12:42:30 GMT

Yes so can i do anything to get round this?

Re: Fixed Expressions on Chart

Mon, 19 Oct 2015 12:59:41 GMT

an idea would be to add types for Other , unreported, do a resident load of your Fact Table but in the resident load, insert If test that check the flag and adj and set the type on those records to the new values (e.g. 7,8).

You could then have your expressions in variables - and then have your chart expression usinging an If test with the variables

I am jsut thinking out loud with this

Re: Fixed Expressions on Chart

ivandrago — Mon, 19 Oct 2015 13:09:12 GMT

I still want the dimensions to show even if there is no results for the condition

Re: Fixed Expressions on Chart

Mon, 19 Oct 2015 13:23:44 GMT

If you select show zeros/null values, those dimensions should still work as long as there are values for them in the Dim table

Also, you could look into Oleg's suggestion as well

Re: Fixed Expressions on Chart

ivandrago — Wed, 21 Oct 2015 00:08:21 GMT

‌Hi Oleg, is it only on the internet I can get this book or would I be able to get this I of the bookstores in the UK?

thanks

Re: Fixed Expressions on Chart

Oleg_Troyansky — Wed, 21 Oct 2015 15:25:01 GMT

Hi Ivan,

I doubt if the book can be found in bookstores, it is too narrow-focused. Amazon.co.UK has it though. Plus, you can get it in any electronic format you wish - Kindle, epub, iBooks...

happy reading!

Oleg Troyansky

Re: Fixed Expressions on Chart

ivandrago — Mon, 02 Nov 2015 13:32:33 GMT

Hi Oleg,

I have brought your book from Amazon for the Kindle which is a great read so far, do you have any suggestions with regards to folder structure, source control, reusing the same qvd's and transforming them qvd's to another folder. There are a few things out there but wanted your suggestions of best practice etc... as getting to the stage where there are more developers starting to use the Qlikview but there is no structure and want to implement this asap.

Thanks