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
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.
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.
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??