New to Qlikview - SQL meaning to Qlikview Expression

[bjjackson2760]

I have the following that I am trying to get totals per plant, but the field is a string therefore I can count them.  However , I can get what I need in SQL but I can't quite put it into Qlikview words.  Can someone please assist? Thanks in advance! Below is the SQL:

select distinct price_plant_code, count(dr_nbr)

from respermits.dbo.SLSD rs

join ResPermits.dbo.permits rp

on rs.division = rp.division

group by price_plant_code, dr_nbr

[bjjackson2760]

This is something I would like on a front end chart, there are alot more tables I am working with that have been uploaded to the script, but I would like to be able to perform this operation in the chart, expression.  Thanks.

[bjjackson2760]

Hi Anil, is there anything in within the chart expression I can do?

[bjjackson2760]

Hi Anil, I probably should not do that as the fields are already uploaded.  I just need to know how to get what I want in the chart expression if possible.

[Anil_Babu_Samineni]

I can't explain with out knowing the Achieve output. Can you please post sample Application and what do you want in chart( Please mention Dimension, Expression which you applied, Please?)

In this Application, Did you connect to the DB to fetch the Table??

[tyagishaila]

first connect to that database where required tables are present.

after that you can direct use your Sql query in qlikview, start with keyword SQL .

i.e.

SQL select * from .....;

[bjjackson2760]

Thank you so much Shaila!