topic Re: values should not change in QlikView

values should not change

ssriramin19 — Thu, 27 Feb 2014 09:21:57 GMT

Hello,

My requirement is that I have a field called unit of measure which contains three values COGS,Selling Units and Price Units.

There is a straight table which has item numbers and sales values as measure.

In the table the sum of sales is sorted in descending order

which ever unit of measure I click the sales amount gets multipiled by corresponding unit of measure and the sales values are displayed in the descending order and the corresponding item numbers are listed .

The requirement is that whenever any unit of measure is selected the item numbers must be related to COGS unit of measure only . The actual quantity when multipled other than COGS need not be sorted in descending order .

Can anyone please help me on to achieve the requirement .

Thanks

Sriram

Re: values should not change

ssriramin19 — Thu, 27 Feb 2014 09:33:10 GMT

Please any one guide me hwo to resolve this issue..

Re: values should not change

Thu, 27 Feb 2014 09:39:18 GMT

share your requirement in qvw and show by example

Re: values should not change

ssriramin19 — Thu, 27 Feb 2014 09:41:22 GMT

The size of the file is very large it cannot be attached here .

Re: values should not change

sujeetsingh — Thu, 27 Feb 2014 09:47:56 GMT

Sri just create a inline table by it with entering the 10 included records and then develope the UI in the same format you have in your dashboard or just with field names same reload your file with inline table .