topic Re: is there any chart with out expression? in QlikView

is there any chart with out expression?

Thu, 12 Jun 2014 06:54:25 GMT

is there any chart with out expression?

Re: is there any chart with out expression?

ashfaq_haseeb — Thu, 12 Jun 2014 06:58:05 GMT

Guage chart

Regards

ASHFAQ

Re: is there any chart with out expression?

its_anandrjs — Thu, 12 Jun 2014 07:01:42 GMT

You are asking for Expression or Dimension if only Expression then the Gauge chart, Bar Chart, Straight Table. But Without Expression in the chart i dont thing there is.

Re: is there any chart with out expression?

MayilVahanan — Thu, 12 Jun 2014 07:03:28 GMT

Try with table box. There is no expression. But you can add any number of fields displayed in it.

Re: is there any chart with out expression?

senpradip007 — Thu, 12 Jun 2014 07:04:21 GMT

Hi Ashfaq.

Gauge chart is designed without dimenssions, not expressions. Try Table Box without expressions.

Re: is there any chart with out expression?

Thu, 12 Jun 2014 07:06:13 GMT

Without Expression ?

Re: is there any chart with out expression?

ashfaq_haseeb — Thu, 12 Jun 2014 07:12:13 GMT

Sorry I thought dimension.

Regards

ASHFAQ

Re: is there any chart with out expression?

its_anandrjs — Thu, 12 Jun 2014 07:13:28 GMT

Yes there is a way of using the table box but you have aggregate or grouped your Dimension and Expression in the load script like

tmpSource:

Load * Inline

[

Dim1,Dim2,Measure

2012,5,159065

2014,6,12567

2014,7,23567

];

SalesAnalysis:

Load

Dim1 as Year,Dim2 as Month,

Sum(Measure) as Sales_Measure

Resident tmpSource

Group By Dim1,Dim2;

After this in the table box plot only Dimension and mesaure from SalesAnalysis table

Year, Month, Sales_Measure

Re: is there any chart with out expression?

Thu, 12 Jun 2014 20:19:14 GMT

Is there any kind of context to this question that could help us provide more helpful answers?

Re: is there any chart with out expression?

Anonymous — Thu, 12 Jun 2014 20:31:59 GMT

No. Expression is the essence of a chart. At the very least you can create, for example, a straight table with a meaningless expression for example 1, or 0, or blank text '' - but at least some expression.

Table box is not a chart.

Re: is there any chart with out expression?

rwunderlich — Thu, 12 Jun 2014 20:57:29 GMT

You can create both Straight Table and Pivot Tables without Expressions -- they would have Dimensions only. You just need to uncheck "Suppress zero Values" on the Presentation tab. It's very handy, especially as an alternative to Table Box.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: is there any chart with out expression?

Anonymous — Fri, 13 Jun 2014 00:50:28 GMT

Ha, indeed... Thanks Rob.

(Sometimes I use straight box to replace table box.)

Re: is there any chart with out expression?

Anonymous — Fri, 13 Jun 2014 01:58:23 GMT

Table Box which can be represented Straight Table with blank expression.

Re: is there any chart with out expression?

Fri, 13 Jun 2014 12:07:08 GMT

Hello everyone,

I like to analyse the Target and Current Revenue.Below is the scenario,

Current Revenue per month- 80,000

My target -1,00,000

Travelling Expenses-10,000

Electricity Charges -3000

Other Expenses -1000.

My Questions is that:

I have a Gauge Chart where One end will display the Current Revenue and opposite will display the Target which I want to achieve.i have three slider control in which Travelling expenses amount,Electricity charges amount and Other Expenses amount are assigned.

If i decreases the Expenses in slider, then automatically my Current Revenue have to increases and

should moves to the target.How can i do this.Give me the code to do it.Please help me.

Re: is there any chart with out expression?

Anonymous — Fri, 13 Jun 2014 12:12:46 GMT

With out Expression ?????

With out Dimension Qlikview having the chart like Gauge chart.....

Re: is there any chart with out expression?

datanibbler — Fri, 13 Jun 2014 12:18:08 GMT

Hi Rob,

could you give some advice to the rest of us here - what would be the point of having a chart with no expression?

Thanks a lot!

Best regards,

DataNibbler

Re: is there any chart with out expression?

rwunderlich — Fri, 13 Jun 2014 14:41:38 GMT

Any time you just want to display the data, without summarizing any measures. For example, showing a detail table, like Customer Name / Address, etc. Think of an expressionless straight table as an alternative to a Table Box -- but with better styling options and the potential to add an expression later if need be.

As a matter of course, I use Expressionless Straight tables instead of Table Boxes.

Or use a Dimension Only Pivot table to show a Hierarchy, Like Manager & Staff, or Product Category/ Subcategory/ Product.

Also useful is a Straight Table with no Dimensions, just Expressions

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: is there any chart with out expression?

its_anandrjs — Fri, 13 Jun 2014 14:47:55 GMT

Thanks Rob,

This is so much helpful in place of table box specially pivot tables

Regards

Anand