Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to Qlikview and facing strange issue with small set analysis expression
This is my expression
SUM({<[Campaign Channel]={'PPC'}>}[Site Visit Vis Num])
Actually there is data for campaign channel and as well for Site Visit Vis Num as I checked individually.
If I combine as expression it is returning '0' for all dates.
Can anybody help me how to resolve this issue. Thanks in advance
Regards,
Kumar
I think you have a calculated dimension, and the expression and the calculated dimension simply do not add up.
You sample file does not contain the file you use in the expression, so naturally this will fail. Please provide sample that match you issue description to add value to the thread.