topic Re: RE:Dimension in QlikView

RE:Dimension

Chanty4u — Wed, 08 Jul 2015 04:10:45 GMT

Hi,guys

how to retrieve a dimension according to expression output?

any suggestions

Thank you

Re: RE:Dimension

Chanty4u — Wed, 08 Jul 2015 04:24:25 GMT

suppose

i have many names repetedly comes for ex(a b a b c a a)

if we hvea coloumn name,price,week,top1,top2

now we have to caluculate total values of a,b,c of coloum(name) as per output 1st greater one wil display in top1 for whole week top2 for whole week

for example a total in week(w1) is 1000 ,b 800,c 100 lik data has to to be in top1 and b has to be in top2

thank u

Re: RE:Dimension

manojkulkarni — Wed, 08 Jul 2015 04:27:20 GMT

Please can elaborate bit more on your query, if possible attach sample file.

Re: RE:Dimension

Chanty4u — Wed, 08 Jul 2015 06:59:06 GMT

Hi manoj,

My output vil be like

agent total value top1name top2value top2name like dat

a 800 anup 600 raj

Re: RE:Dimension

avinashelite — Wed, 08 Jul 2015 07:03:03 GMT

Hi Suri,

In the chart properties you sort the values in the descending order so you will get the top values at the top and if you want only the top 3 or 1 in the straight table you have the dimension limit option you can check this accordingly.

or you can try with the ran function too

Re: RE:Dimension

Chanty4u — Wed, 08 Jul 2015 07:19:57 GMT

Hi,

Tanq avinash can u look into the attched qvw

am nt getting the exact output..

Thank u

Suresh

Re: RE:Dimension

Kushal_Chawda — Wed, 08 Jul 2015 07:29:07 GMT

Please provide sample data

Re: RE:Dimension

Chanty4u — Wed, 08 Jul 2015 07:32:34 GMT

can u look into attched qvw

Tanq

Re: RE:Dimension

Kushal_Chawda — Wed, 08 Jul 2015 07:38:43 GMT

Data is not available in qvw

Re: RE:Dimension

Kushal_Chawda — Wed, 08 Jul 2015 07:41:53 GMT

i think data is not proper in you qvw. load your excel with embedded label

Re: RE:Dimension

avinashelite — Wed, 08 Jul 2015 07:45:15 GMT

hi suri,

Please share the data as well , its need script change

Re: RE:Dimension

Chanty4u — Wed, 08 Jul 2015 07:48:16 GMT

sry for dat..

PFA

Re: RE:Dimension

Kushal_Chawda — Wed, 08 Jul 2015 09:05:41 GMT

do you need only top 2 or it should dynamic?

Re: RE:Dimension

Chanty4u — Wed, 08 Jul 2015 09:27:42 GMT

hi,

i need to dispaly like dat it may be a dynamic or nt...no issues

Re: RE:Dimension

Kushal_Chawda — Wed, 08 Jul 2015 09:58:02 GMT

please find the attached file.