Solved: Displaying dimension values in a chart when there ... - Qlik Community

Report Inappropriate Content · ‎2014-02-26

I have two customers, one of which has some purchase and sales transactions and one which doesn't.

I would like to create a chart which sums the purchase and sales totals for each client AND displays both clients, even though one will not have any transactions to sum.

Many thanks in advance for any suggestions

MK_QSL · ‎2014-02-27

Create a Straight Table

Dimension = CLIENT_NAME

Tick Suppress When Value is NULL

Tick Show All Values

Expressions

Purchase : SUM({<TransactionTypeCode = {'P'}>}Quantity)

Sales : SUM({<TransactionTypeCode = {'S'}>}Quantity)

Purchase Total Value : SUM({<TransactionTypeCode = {'P'}>}Amount)

Sales Total Value : SUM({<TransactionTypeCode = {'S'}>}Amount)

View solution in original post

MK_QSL · ‎2014-02-26

Like This?

Report Inappropriate Content · ‎2014-02-26

Hi Manish,

Thanks for the quick response - unfortunately I've only got the personal edition so can't open your test qvw - Could you let me know what the fix is and I'll give it a go.

many thanks

john

Report Inappropriate Content · ‎2014-02-26

If you want to display zero-values go to the presentation tab on the object and uncheck "Suppress zero values."

MK_QSL · ‎2014-02-26

Go to presentation tab and untick suppress zero

Report Inappropriate Content · ‎2014-02-26

Hi Christian

Unchecking the suppress zero values didn't work; I guess because there aren't any values in there at all?

PrashantSangle · ‎2014-02-26

Hi john,

You can achieve this by un check Supress zero value option in presentation tab.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-02-26

I'd say try unchecking suppress missing on the presentation tab and then try unchecking suppress nulls on the dimensions tab.

MK_QSL · ‎2014-02-26

Create a document by adding below in your script.

Load * Inline

[

Customer, Purchase, Sales

A, 100, 200

B, 120, 240

C, ,

];

Now Create a Line Chart or Bar Chart..

Dimension = Customer

Expression = SUM(Purchase) + SUM(Sales)

Now Go to Presentation tab and untick Supress Zero Values...

Hope this helps...

Report Inappropriate Content · ‎2014-02-26

Thanks - I'll give it a try and let you know

Displaying dimension values in a chart when there are no records for the expression to calculate