Discussion Board for collaboration related to QlikView App Development.
I have a senario, i am attaching a sample. I have a listbox name 'status'. As of now i have to show count of each status.
for eg: open,closed,...now in expression i m giving hardcode expression like :
later another status may get added like., inprogress....instead of status...i need dynamicaly...so that
automaticaly it should get added.
can u plz help on this
add both dimensions "dim,Status " as dimension and write your normal expression as follows
View solution in original post
If you need you need to show this in a list box just check "Show Frequency" flag in the list box setting.
If you mean a chart I'd use 'status' as dimension and 'Count(status)' as an expression.
your ans helped me..thankx...small thing is when i use it in pivot and drag...i dont need the dim name...
i have attached a screen short !
go to Properties>Dimension and select status >> in the label press space
Please find the application attached