Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

set analysis and if

Hi,

if have variable which contains if and set analysis and i dont want to change it.

but if i want to add if before the variable - the answer is not correct.

for example - Sales=

$(vMeasure) =if(VAT='NO VAT', sum( {< YEAR = {$(vCurrYear)} >} [TOTAL SALE)],sum( {< YEAR = {$(vCurrYear)} >}[TOTAL SALE AND VAT]))

now i want to show sales for branch 121 all the time (but still without changing $(vMeasure)


Sum({<branch={121}>} aggr ($(vMeasure_CY),[month and year]))  - But it doesnt work

How can i do it??

help

11 Replies
Anonymous
Not applicable
Author

i wish it was the problem

avinashelite

please share the sample data