Hi Is there a way to compare the count of position of 'a' ,'b','c','d',.......'l' o Compare 1 and color code the text? rangesum(num(count(distinct left('abcdefghijk','1')))) gives me 1 rangesum(num(count(distinct left('abcdefghijk','2')))) gives me 1 i couldnt figure out how to write a comparison stmt. is this possible? thanks
Re: compare count of each string value to a measure
Hi sorry for the delayed reply. By basic need is to get a 100% stacked chart in a table .I think I solved it finally. There is alot of work around though.
I have a mix a excel logics to get the 100 % stacked bar chart. The reason I wanted to use a Range function is I wanted to take 100 cells as we take in excel and compare the ranges of my measures with that cell range. But didnt know which one to get it . I tried to replicate this in Qlik. https://trumpexcel.com/stacked-bar-chart-in-excel/.
I figured I have to use Rangeonly function to get the 100% stacked bar chart.
AS 100 % was too much to show in a column I wanted to reduce the %- so 20% stacked is reduced chart.