Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

set analysis

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

6 Replies
Highlighted

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

Highlighted
Specialist III
Specialist III

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

Highlighted
Creator II
Creator II

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

Highlighted

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

Highlighted
Specialist
Specialist

We can get this format in straight table.

Highlighted
Contributor III
Contributor III

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