Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

merging to expresion

AOA

I have a table in which i m showing sum of bal_qty for only thos voucher having value LIV

sum({<VOUCHER_ID={'LIV'}>}BAL_QTY)

Now I also want that selection of year and month dimension doesnot effect on this table.

sum({<YEAR,MONTH=>}BAL_QTY)

NOW this two exprsion are working fine individualy how to combine them on single expresion to get desired out put

which is

(sum of bal_qty where vouvher_id='LIV' and free from year and month selection)

regards

1 Solution

Accepted Solutions
christian77
Partner
Partner

Hi, try this...

sum({<VOUCHER_ID={'LIV'}, YEAR= ,MONTH= >}BAL_QTY)

View solution in original post

3 Replies
christian77
Partner
Partner

Hi, try this...

sum({<VOUCHER_ID={'LIV'}, YEAR= ,MONTH= >}BAL_QTY)

View solution in original post

er_mohit
Master II
Master II

Sum({$<VOUCHER_ID={'LIV'}, month = ,year=>}BAL_QTY)

sujeetsingh
Master III
Master III

You can take these as two seperate expressions.