Selected fields backend query

[#1]

Hi

I Used KPI component.I placed Sum(Total).I want to know what query hit in back end .I want to know based on that i will consider my query is correct or wrong.

E.g/

Select Sum(Total) from Expense.

Some time i can see records in table .But when i select in chart,i am not able to see any records.Thats why i need to analysis.

Thanks

Govind R

[sunny_talwar]

No idea as to what you are trying to do. Can you provide some more information? Images? Sample?

QlikCommunity Tip: How to get answers to your post?

[#3]

I placed some measured attributed into chart.E.g Sum(Total) in KPI component. Now i want to know what is the back end query writing in qlik engine.I want to cross verify my qlik sense query as well my direct data base query.

E.g

I writing query in toad or sql developer

Select sum(Total) from Fact. Result-->4000

But my report showing 3000.No joing any tables.So how can i verify report query.?

Thanks

Govind R

[#4]

HI Friends

Can you please give me solution above post.

Thanks

Govind R