Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
bjjackson2760
Contributor
Contributor

New to Qlikview - SQL meaning to Qlikview Expression

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

15 Replies
bjjackson2760
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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

bjjackson2760
Contributor
Contributor
Author

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tyagishaila
Specialist
Specialist

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
Contributor
Contributor
Author

Thank you so much Shaila!