Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In chart try some think this way
if(Account='expenses',sum(amt))
Regards
Anand
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
im aware of your query, I have lot of Accounts information, which cant be accommodated in where clause
I want use in the control
I did not understand what do you mean by control or you are asking about the Qlikview front end.
Regards
Anand
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
In chart try some think this way
if(Account='expenses',sum(amt))
Regards
Anand