topic Re: Range % in QlikView

Range %

Thu, 19 Jun 2014 12:00:26 GMT

Hi,

Need help please. I want to show % of number of applications of each range as in Colomn C in the table as attached. Either in a new table ot wahatever but it should look like in a table:

Range Applications

0-5 5000

5-10 4000

10-15 3000
etc.

Also as I am using personal edition qlikview so cant download any qlikview file. could you please paste expression/ script in the message

Re: Range %

Thu, 19 Jun 2014 12:07:53 GMT

Hi,

you have to calculate the range into the script in order to make a dimension.

Then, it enables you to have a selection and count your dataset having the range you want.

Regards,

Benjamin Drouin

Re: Range %

Thu, 19 Jun 2014 12:11:40 GMT

Could you please tell stwp by step. How?

Re: Range %

Anonymous — Thu, 19 Jun 2014 12:38:36 GMT

Create a calculated dimension using the same logic you created in "C" and check.

It should work

Re: Range %

Thu, 19 Jun 2014 13:25:01 GMT

Jebamalai, it did not work

Re: Range %

Anonymous — Thu, 19 Jun 2014 13:28:38 GMT

Hi Shoaib,

Pls send me the calculated dimension you created.

Because in your table you have created with two other parameters.

Need to check the complete logic

Regards

Jeba

Re: Re: Range %

Thu, 19 Jun 2014 13:31:09 GMT

Please find as attached. Please let me know here becuase I cant download qlikview file ( using personal edition). thanks