topic Re: Translating Excel Conditional Format to Qlik Expression Representation in QlikView

Translating Excel Conditional Format to Qlik Expression Representation

Anonymous — Fri, 04 May 2018 13:36:55 GMT

Qlik World,

I am in the process of translating an Excel pivot table into a comparable Qlikview version. Most of the work has been done, but I want to see if there is a way to make the two versions match better:

Excel: QlikView:

Is there another option in Qlik that is closer to the Excel formatting? The Excel is a PivotTable using the Conditional Formatting/DataBars option. The QlikView is using a linear gauge.

Thanks for any help you can provide!

Re: Translating Excel Conditional Format to Qlik Expression Representation

adityaakshaya — Fri, 04 May 2018 21:27:18 GMT

Hi Jordan,

There is a work around through this, you can change the background of the cell using Visual Cues option.

I am attaching a demo app for your reference.

Regards,

Akshaya

Re: Translating Excel Conditional Format to Qlik Expression Representation

Anonymous — Fri, 04 May 2018 22:47:31 GMT

Thank you, Akshaya! I will try this out soon and report back how it works.

Re: Translating Excel Conditional Format to Qlik Expression Representation

Anonymous — Wed, 16 May 2018 15:21:21 GMT

This didn't quite solve the issue as the color condition isn't the focus. There doesn't seem to be a Qlik equivalent metric view where a value can be included in the minichart as it appears in Excel. That's more the end result we were seeking; otherwise we would have to have two columns like such to display the data both in minichart and numerical value: