Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Translating Excel Conditional Format to Qlik Expression Representation

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:

1.jpg 2.jpg

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!

3 Replies
adityaakshaya
Creator III
Creator III

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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:

1.jpg