Discussion Board for collaboration regarding Qlik DataMarket.
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 .
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 ?
what are dimensions and expressions ?
is it if(isnull(station),'N/A') ?
if so : if(isnull(station),'N/A',station)
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 !
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 ?
The detail in the excel file is this one:
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
you have two ewpressions no ?
pareto % ?