topic Re: Need help on Creating pivot table with arrows in QlikView

Need help on Creating pivot table with arrows

venkanna_info — Fri, 07 Jul 2017 05:55:48 GMT

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.

Thanks,

Venkanna

Anil_Babu_Samineni — Fri, 07 Jul 2017 05:59:45 GMT

Normally, we can write like below

If(TYYTD Expression < LYYTD Expression, RedAroowImagePath,

If(TYYTD Expression > LYYTD Expression, GreenAroowImagePath))

ahaahaaha — Fri, 07 Jul 2017 07:24:31 GMT

Hi Venkanna,

May be like this

Regards,

Andrey

venkanna_info — Fri, 07 Jul 2017 12:05:42 GMT

Thanks for your prompt response.but can u tell me how it works in qliksense?