Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhuprakash
Creator II
Creator II

Data allign in Pivot

Team,

Please check the below Dashboard. I want Active counts row as given in dashboard.

Active = Total - Drop/Opt-out

er.png

14 Replies
bhuprakash
Creator II
Creator II
Author

yes Tresesco,

Exactly I want this. Thanks a lot for your quick support.

Also thank u Anil for your quick help.

bhuprakash
Creator II
Creator II
Author

But please check =if(dummy=1) like code is showing in column.

Please check this

tresesco
MVP
MVP

You can change the label like:

Untitled.png

Anil_Babu_Samineni

What if Dummy Field is not available? I meant, If we don't have field with some sequential order. Then, How we can develop?

Just to know - If you have time please reply.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

Dummy is not required to be sequential. It can be anything as an island. And if you don't want a new field in the script, you might have to use synthetic dimension; using valuelist()/valueloop(), which I don't prefer in such cases.