Discussion Board for collaboration related to QlikView App Development.
Make a pivot table taking County, Sales office, Employee name and measures as TY YTD sales, LY YTD sales and Year salary.
Color code: TY YTD<LY YTD, RED arrow down
Color code: TY YTD>LY YTD, Green arrow Up
I am facing problem while creating arrows as per above condition.Can anyone help me on the same.
Normally, we can write like below
If(TYYTD Expression < LYYTD Expression, RedAroowImagePath,
If(TYYTD Expression > LYYTD Expression, GreenAroowImagePath))
May be like this
Thanks for your prompt response.but can u tell me how it works in qliksense?