Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
adambrian
Contributor III
Contributor III
‎2017-02-19 05:24 PM

View Current Selected Field

Hi,

I beginner in Qlik Sense, can you help me

2017-02-20 06_08_04-soalan.xlsx - Excel.png


I want to calculate and show in pie chart, if i select any UNIT and need to compare same UNIT=OLD_UNIT.

For example i select unit1 in department A:


1) show GROUP count by STAFF_ID where if i select an@y unit getfieldselections(UNIT) and if UNIT=OLD_UNIT


2) show DEPARTMENT count by STAFF_ID where count all STAFF_ID except unit1 in department A.

getNotfieldselections(UNIT) and if UNIT=OLD_UNIT


And what should i put in Dimensions and Measure field?


mto‌ swr‌ swuehl‌ stalwar1‌ gwassenaar‌ jagan‌

208 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2017-02-20 08:24 PM

I am not 100% sure what the expect output you are looking to get. Would you be able to share numerical result you are hoping to see when you select Unit1. Also, are you selecting Department A also or just Unit1?

112 Views
0 Likes