Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
omaradel
New Contributor

Hi there i am new please help

HI all

Can any one tell me how to write this sql command in Code area of a field here

Select * from RVW_Modified_Sheet where Type = 'Assets'

OR

Select * RVW_Modified_Sheet where account_code like '10%'

1 Reply
Highlighted
omaradel
New Contributor

Re: Hi there i am new please help

btw i tried an if statement and it didn't work

=if(Type = 'Assets' , SUM(Balance) , 0 )