topic set analysis in QlikView

set analysis

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In a pivot table I have two dimensions Hour and Weekday.

In the expression i need to put this if logic

=if(LWCHRG.OPPD_PERS_PROP='PERSONS',COUNT({<CHRGCNT={'1'},NAME_CODE={'VI'},CASE_DISPOSITION={"*"}-{'1'}>}CHRGCNT),

if(LWCHRG.OPPD_PERS_PROP= 'PROPERTY',Count({<CHRGCNT={'1'},CASE_DISPOSITION={"*"}-{'1'}>}CHRGCNT),

if(LWCHRG.OPPD_PERS_PROP= 'SOCIETY',count({<CHRGCNT={'1'},CASE_DISPOSITION={"*"}-{'1'}>}CHRGCNT))))

But I cant take LWCHRG.OPPD_PERS_PROP as a dimension in my table. so i am not getting any thing in table.

Is their any way to put this expression in the pivot table without dimension LWCHRG.OPPD_PERS_PROP.

Please help me to do.

Thanks

Re: set analysis

avinashelite — Tue, 27 Sep 2016 09:58:47 GMT

I don't think it would be possible , you need a metric upon which the calculation need to be done , you could try with the straight table you will get the option to hide the dimension

Re: set analysis

miguelbraga — Tue, 27 Sep 2016 10:00:23 GMT

Hey there,

Can you specify further your issue giving us a sample data and the expected output I couldn't understood your problem.

Best regards,

D.A. MB

Re: set analysis

bhavvibudagam — Tue, 27 Sep 2016 10:07:10 GMT

but client want to see the chart as per the attached image.So I have to take pivot table only.

Re: set analysis

avinashelite — Tue, 27 Sep 2016 10:12:42 GMT

Since you have fixed expression list you could add this format in straight table rite ??

Re: set analysis

varshavig12 — Tue, 27 Sep 2016 11:54:47 GMT

We can get this format in straight table.

Re: set analysis

gilbertomedeiro — Tue, 27 Sep 2016 21:55:49 GMT

Hi Bhavvi,

If I understand your issue, you need keep the pivot table without dimensions and sometimes you need to change this pivot table in a pie chart, for exemplo, is not it? So, If am I right, you should do that in your application. Take a look in a sample attached.

I hope it's solve your problem!

Regards,

Gilberto