Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

How to write the expression

I got a chart like below :

Capture.PNG

By default , I don't want to show Precessed . so thus , I used the expression fo 'Sales Value'

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales={'*'}-{'Processed'}>} Amount) Capture.PNG

Then getting the above chart, which is my requirement.

But , when I am trying to select 'Unprocessed' and 'Unspecified' then it is not selecting.

How can I select 'Unprocessed' and 'Unspecified' ?

1 Solution

Accepted Solutions
Peter_Cammaert

With this?

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales -= {'Processed'}>} Amount)

View solution in original post

3 Replies
Peter_Cammaert

With this?

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales -= {'Processed'}>} Amount)

View solution in original post

Kush
MVP
MVP

would you be able to share the sample?

balrajahlawat
Champion
Champion

Just Click on 'Unprocessed'...see whether selection is happening.

Also make it fully compressed either by clicking on + sign or

Properties - > Presentation - > Always Fully Compressed(Left Bottom)