topic chart control sum in QlikView

chart control sum

Sat, 13 Dec 2014 13:17:06 GMT

Im using qlikview 8.5

The below is query is used for chart control and works fine

SQL SELECT

Day(PostingDate) as InvoiceDay,

Month(PostingDate) as InvoiceMonth,

Year(PostingDate) as InvoiceYear,[EntryType]

,[BillNo]

,[Description]

,[amt],Account

FROM IETracking;

and I have other chart control I need to show only the sum(amt)

where Account=expenses.

How can i do that in chart control

its_anandrjs — Sat, 13 Dec 2014 13:39:30 GMT

Hi,

In the load script write like

SQL SELECT

[BillNo]

,[Description]

,Account

,Sum([amt]) as AmtSum

FROM IETracking Where Account='expenses'

Group By [BillNo],[Description],Account;

Regards

Anand

Sat, 13 Dec 2014 13:46:18 GMT

im aware of your query, I have lot of Accounts information, which cant be accommodated in where clause

I want use in the control

its_anandrjs — Sat, 13 Dec 2014 13:48:44 GMT

I did not understand what do you mean by control or you are asking about the Qlikview front end.

Regards

Anand

Sat, 13 Dec 2014 16:29:14 GMT

in chart properties in the expression tab, see if i can

if Account='expenses' sum(amt)

im not exactly sure, where to add this logic

its_anandrjs — Sat, 13 Dec 2014 16:50:57 GMT

In chart try some think this way

if(Account='expenses',sum(amt))

Regards

Anand