Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to merge 2 formulas into one in Qlikview expression.
Formula 1 : =Sum({$<Item_Type = {'N'} >} [Total Sales])
Formula 2 : = Sum ({$<REFERENCE= p({1< [Product Code] = {'0000048565660'}>} REFERENCE) >} [Total Sales])
Thk very much.
Parakorn.T
@parakorn
Hi please check that - Solved: Qlik sense : set analysis (and / or) - Qlik Community - 1337192
Hi Sir
Thk for link, I try to learn and adapt to my formulas but criteria 2 does not work, the result is still equal at last.
I don't know what is wrong.
A New Formula
=Sum({$<Item_Type = {'N'} >+$<REFERENCE= p({1< [Product Code] = {'0000048565660'}>} REFERENCE) >} [Total Sales])
try this -
Sum({$<Item_Type = {'N'} ,REFERENCE= p({1< [Product Code] = {'0000048565660'}>} REFERENCE) >} [Total Sales])
Hi @parakorn ,
What is your actual result and the expected one ?
What is the business logic behind the expression ? what are you trying to achieve ?
Best Regards
Thk you sir
I received 2 formulas from QV report of my company,
One Sumif by type of sales 'N'
and Two Sum-only tickets had item '0000048565660' in the lists then
I want to Sumif by type 'N' and the only ticket had item '0000048565660'
Sorry if you don't understand, I'm not good at Eng languages.
The result is still equal, I want to filter bills that had Item '0000048565660' and Item_Type = 'N' and sum that.
@parakorn It should be equal,there is one formula with 2 conditions,can you please send some examples for the input and the output that you expect?
