Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Dynamic change of expression

Hi friends,

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 :

Count({<status={'open'}>}status)

Count({<status={'closed'}>}status)

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

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: Dynamic change of expression

add both dimensions "dim,Status " as dimension and write your normal expression as follows

Count(status)

View solution in original post

5 Replies
Highlighted
Specialist II
Specialist II

Re: Dynamic change of expression

add both dimensions "dim,Status " as dimension and write your normal expression as follows

Count(status)

View solution in original post

Highlighted
Partner
Partner

Re: Dynamic change of expression

Hi,

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.

Best regards,

Maxim

Highlighted
Creator II
Creator II

Re: Dynamic change of 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 !Untitled.png

Highlighted
Specialist II
Specialist II

Re: Dynamic change of expression

go to Properties>Dimension and select status >> in the label press space

Highlighted
Partner
Partner

Re: Dynamic change of expression

Hi,

Please find the application attached