topic Re: Is there any expression to find frequency in QlikView

Is there any expression to find frequency

Wed, 11 Sep 2013 12:12:29 GMT

Hi,

If we see list box we have an option 'show frequency' in general tab while enabling that option it is showing the count in left corner side , so it is not visible while change to web view , is it possible to move the value according to our wish or is there any expression to find the frequency ?

Thanks,

Re: Is there any expression to find frequency

simondachstr — Wed, 11 Sep 2013 12:26:02 GMT

For me it is visible in WebView. If you wish to make your own calculations simply do it by using an expression in the expression tab.

Re: Is there any expression to find frequency

tresB — Wed, 11 Sep 2013 12:28:54 GMT

You can try count() function.

Re: Is there any expression to find frequency

Wed, 11 Sep 2013 12:36:38 GMT

Hi,

Thanks for the reply ,

Can you please let me know how to write expression to get show frequency .

Thanks,

Re: Is there any expression to find frequency

tresB — Wed, 11 Sep 2013 12:44:08 GMT

Listbox-> add Yourdimension ->Expression: Count(Yourdimension)

This will show your dimension values and frequency (similar out put as checking the 'Show Frequency') side by side.

Re: Is there any expression to find frequency

Wed, 11 Sep 2013 12:50:45 GMT

Hi ,

Actually my requirement is i have to create one button to disply show frequency ,

If i click on that button it has to point to the container it is having list boxes there in list boxes has to disply show frequency values and if they double click on button it won't disply the frequency ,

It is possible ?

Thanks ,

Re: Is there any expression to find frequency

Wed, 11 Sep 2013 12:52:46 GMT

Hi ,

Thanks for the reply,

That's working fine but my requirement is i have to create one button to disply show frequency ,

It is possible ?

Thanks ,

Re: Is there any expression to find frequency

dmohanty — Wed, 11 Sep 2013 12:54:31 GMT

May be due to space constraints, the Frequency values are not visible in AJAX. Could you try in dragging the List box bit wider in Desktop mode, Change it to WebView and check if its visible.

Re: Is there any expression to find frequency

tresB — Wed, 11 Sep 2013 12:54:52 GMT

You can put a condition for enabling the frequency expression. Set a variable on button click and put that variable value in the enabling condition.

Re: Is there any expression to find frequency

tresB — Wed, 11 Sep 2013 12:58:13 GMT

PFA

Re: Re: Is there any expression to find frequency

Wed, 11 Sep 2013 13:15:38 GMT

Please add the expression to the Listbox --> Expression --> Count(Dimesion)

Create a variable vShowHide = 1, Please change these values on button. Use this variable on the Conditional expression for List box expression.