Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, is there anything in within the chart expression I can do?
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??
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 .....;
Thank you so much Shaila!