Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Highlighted
lessassy
New Contributor

Display data from Excel Files in a bar chart

Hello everyone,

I have some cell in my excel files wich are stations, STATION is a field.

The typical names for these stations are : S1350, S1355; S0950 or N/A when there is no indication.

I tried to display a bar chart which highlights some value per station.

Unfortunately it's not working becasue Qlik view doesn't display the value "S1350" because there is a letter and a number in the same word.

Anyone would have a solution for this .Pareto one value.PNG

In the bar chart there are only N/A whci appears. Whereas there's still many  stations with some data to display ?

Anyone has a solution ?

Thank you

5 Replies
ogautier62
Valued Contributor II

Re: Display data from Excel Files in a bar chart

Hi,

what are dimensions and expressions ?

is it if(isnull(station),'N/A')      ?

if so  :    if(isnull(station),'N/A',station) 

regards

lessassy
New Contributor

Re: Display data from Excel Files in a bar chart

Hello,

Thank you for the answer.

I have one dimension: "station" (so basically all stations with names like "S2350, Q7638, T4567 and so on)

My expression is Sum(KPI Value)

In that case what formula could i use ?

Thank you !

ogautier62
Valued Contributor II

Re: Display data from Excel Files in a bar chart

ok,

and what is expression detail of sum(kpi value), there's a set analysis ?

it's curious, it seems like a condition false

why do you think it's because of mix letter/number ?

lessassy
New Contributor

Re: Display data from Excel Files in a bar chart

The detail in the excel file is this one:

Qlikview - Values KPI.PNG

The station field is "Text" Format in Excel.

So i don't know why the bar chart doesn't display the station in the axis

ogautier62
Valued Contributor II

Re: Display data from Excel Files in a bar chart

you have two ewpressions no ?

pareto % ?